Multiple table queries

Hello Maurice,

Hope you enjoyed your Microsoft Access course with BEST STL Training.
Thank you for your question regarding Multiple table queries in Access.

You can create queries that have more than one table in the source. To do this is fairly simple. Select a table that has a relationship to an existing table in your query. For instance, you might go for Supplier and Product tables.

Make sure that there is a foreign key in the products table, that contains the code of the supplier. This will allow you to link the fields together, and form a relationship.

Add the second table to the query, using the ADD TABLE button in the toolbar. Then link the two tables together by dragging the common field from one table to the other.

Then simply proceed as you would notrmally, adding fields to the query, by double clicking them in the table lists.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post.
Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Richard
Microsoft Office Specialist Trainer