Effat has attended:
Access Introduction course
Queries- Miscrosoft Access
How many criteria can I add to one query?
RE: Queries- Miscrosoft Access
Hi Effat,
Thank you for your post, welcome to the forum
The max number of fields in a recordset of a query is 255, with a max of 32 tables.
If you type 'Microsoft Access Specifications' under Help, you can see the Query specifications in there.
I hope that has helped, regards Pete