SAVING MULTIPLE QUERYS

[Arnold_M._Rosenbaum__(Guest)]

I WOULD LIKE TO SEE THE PROGRAM ALLOW FOR DIFFERENT QUERY^S WHICH CAN BE SAVED INTO ONE REPORT.____CURENTLY IF OYU HAVE THE DIFFERENT QUERYS YOU HAVE TO SAVE THE REPORT UNDER A DIFFERENT NAME

[kfleming]

There is a way that you can accomplish conditional queries.____First create a FLAG field. In Version 9 you can make this flag field a parameteRR field so that you will be prompted to select its value when you run the report.____Then in your query expression, you would use a combination of clauses.____For example if Query 1 is CUSTNO=123__and Query 2 is ORDATE>01/01/2001____your saved query would be:____(FLAG=^C^ and CUSTNO=123)__OR (FLAG=^D^and ORDDATE >01/01/2001)____so if FLAG is set to C you get query 1 and if it is set to D you get query 2.____And Version 9 can prompt you to enter either C or D so you can get two reports for the price of one.____Regards,__Kathleen__R&R Support____