In the attached database, I have a frmSelection which picks the meter point and generates qrySelect, which generates multiple other queries. The problem is that there are three meter points Cascade Grain, Entire System and Georgia Pacific which are combinations of multiple meters. I tried an if statement in the meter# field which went something like IIf ( Forms![frmSelection]![cboMeterPoint] = "Cascade Grain", 3229 or 3230, [Meter #] ) and other variations but they do not seem to work. I understand I have organized the data poorly, but I don't think this should affect this particular problem. I have attached the database in the mdb format. Ah I can't seem to upload is there a problem with the website right now?