querying

AI Training: For Busy Decision Makers & Professionals Book now

Forum home » Delegate support and help forum » Microsoft Access Training and help » Querying

Querying

resolvedResolved · Medium Priority · Version 2003

Julie has attended:
Excel Intermediate course
Access Introduction course

Querying

How many or options do you have.

RE: querying

Hi Julie

My apologies for the delay

Firstly you can query up to 32 tables in a query.

Also the number of nested queries that you can have is 50.

Nested queries are a bit more complicated than OR but I would say that 50 would probably be the limit.

Hope that helps

Thanks

Newson

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

Design View in Relationship window

Your in the Relationship window and changes are required to be made to a Table's design.

Rather than exiting the Relationship window, if you perform a right-mouse click on the table, it opens that table up in Design view

View all Access hints and tips


Server loaded in 0.11 secs.