Page 1 of 1
The order of queries
Posted: Wed Feb 16, 2005 12:31 pm
by happydermis
Hi,____Does the order of the queries in a report have a meaning? Is it possible that a certain order of queries will deliver a false report?____Thanks, Dekers
=> RE: The order of queries
Posted: Wed Feb 16, 2005 4:08 pm
by kfleming
It is only important when you have clauses that are joined by both AND and OR operators. In this case, you may need to add additional parentheses to force the desired order or evalution.____FIELDA=1 and FIELDB=2 or FIELDB=3____will give you all the FIELDB 3 records with any value of FIELDA____Where__FIELDA=1 and (FIELDB=2 or FIELDB=3)____will give you all the FIELDA 1 records where FIELDB has either a 2 or a 3.____Kathleen__R&R Support