linking tables

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Linking tables

Linking tables

resolvedResolved · Medium Priority · Version 2003

Parnam has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

Linking tables

Would it be possible to link 2 external tables to a query and how?

RE: linking tables

Hi Parnam,

Thank you for your question.

If you open the database and then open the File menu and choose Get External Data and Link Tables.

Find the database that contains the table you want to query and click Link.

Then select the table you want to link to and click OK.

Now you can query the External Table.

I hope this answers your question.

Regards

Simon

Thu 5 Mar 2009: Automatically marked as resolved.


 

Access tip:

Space marks

It is good practice not i to have space marks for field names as this can lead to problems when using queries or VBA code. It is much better to use an underscore charcter to represent spaces in field names

View all Access hints and tips


Server loaded in 0.08 secs.