The order of queries

[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

[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