T Tan Mar 23, 2004 #1 Dear all, Any one have idea how many table Ms Access can select to make up a query?
C Cheryl Fischer Mar 23, 2004 #2 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.
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.
