querying
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

Querying

resolvedResolved · Medium Priority · Version 2003

replyReply Mon 13 Sep 2010, 16:49Delegate Julie said...

Julie has attended:
Excel Intermediate course
Access Introduction course

Querying

How many or options do you have.

For upcoming training course dates see: Pricing & availability

replyReply Wed 15 Sep 2010, 10:59Trainer Newson said...

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

 

Please browse our web site to find out more about
access+course and other Microsoft training courses.

Access tip:

Add date to a field

Press CTRL+SEMICOLON

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard