|
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.
|
