How many table can join by using Ms Access Query?

C

Cheryl Fischer

Rachel,

Your question appears identical in wording to one posted by Tan a couple of
hours earlier, so my answer is identical:

In Access 2002, one can have 32 tables in a query. If you are not using
Access 2002, you can find out what this limitation is in your version of
Access by opening Help and then typing: specifications in the Answer
Wizard.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Joining 2 tables to make a query 5
How many table can Ms Access Query? 1
How to export table from outlook into ms access table? 0
Join using LIKE 11
Thin join line in query after establishing RI in Relationship Wind 3
Good morning 5
Query duplicates results due to many-to-many relationships 5
Query Questions 3

Top