Forum home » Delegate support and help forum » Microsoft Access Training and help » Queries
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Queries
Resolved · Low Priority · Version 2003
Reply Thu 20 Nov 2008, 16:50Delegate Joel said...
Joel has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Queries
How do I link more than 3 tables in a query?
For upcoming training course dates see: Pricing & availability
RE: Queries
Dear Joel
Thank you for attending Access Intermediate course!! I hope you enjoyed the course and benefited from it.
Access is a Relational Database which means that as long as the tables are linked correctly to each other directly or indirectly you should be able to extract any field or records from any table while creating a query.
If you are querying tables that have many-to-many relationship then it is important to display the junction table (The table that combines the two tables). You may still get some results but they may not make any sense at all.
I hope this has answered your query.
If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
Mon 12 Jan 2009: Automatically marked as resolved.
|