Home
What is MS Access
Forms
Queries
Reports
VBA Codes
Learn VBA
Access 2007/10
Access 97
Tips via email
Whats New!
Contact Me
Questions Answered
Tables

[?] Subscribe To This Site

XML RSS
Add to Google
Add to My Yahoo!
Add to My MSN
Subscribe with Bloglines



Quick Tips for Queries

Maximum number of tables in a query = 32

Maximum number of fields you can sort by in a query = 10

Level of nested queries = 50

Queries sort from the left to the right, so arrange your columns accordingly.

To find Null values in a query enter Is Null in the criteria section.

To find values that are not null enter Not Is Null in the criteria section.

Remember zero length strings (“”) are not the same as Null.

Cannot see all of the information in a section of a query? Then right click and select ‘Zoom’

 

Do you like this tip? Subscribe to my weekly Newsletter to receive tips weekly via email. Click Here to subscribe.