How many table can join by using Ms Access Query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear All

Anyone have Idea how many table Ms Access can join to make up a query?
 
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.
 
You must log in or register to reply here.

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

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

Back
Top