Short version:
I want to use 1 query with a change in criteria difference. This way I can drop 1 report.
I have been clicking CB1 to open qry1 with output on rpt1 and CB2 to open qry2 with output on rpt2
QRY1 and QR2 have the same fields, but with differing criteria. Report1 and Report2 are the same but look at different query for information.
Example
Query1 - Criteria - <> X in Column 1
Query2 - Criteria - <> Y in Column 1 and = X in Column 2
Command Button1 opens Query1 and spits out Report1
Command Button2 opens Query2 and spits out Report2
I would like to click CB1 to open Query1 with qry criteria and spit out info in Report1 and click CB2 to open Query1 with QR2 criteria and spit out info in Report1
Basically making 1 query with changing criteria pushing information to 1 report.