LONG time to wait for 4xcriteria query to run (5 seconds)

[gangel]

Hey everyone!

SO I have created a query that shows a bunch of prescriptions at my pharmacy that are requiring payment still, and i have filter text boxes above the query (in parent) which filters my query results.

TABLE:
ID - cust Name - Medication - Company - Payment ID

Query:
As above but PaymentID is NULL

cust field:
criteria "Like * & parent!txtcustomer & *"

etc etc for ID, med and company (and 2 others) but you get the point

Because the company or med might be NULL on the actual field i have things like



ID: "Like * & parent!TxtID & *"
Cust (as above)
Employer is null
Medication like * parent!txtmed

Then next line is

ID: "Like * & parent!TxtID & *"
Cust (as above)
Employer like * parent!txtEmp
Medication is null


So i have 4 criteria lines with criteria for about 5 fields based on text boxes...



Ill post a photo too as i KNOW this is confusing.

Anyway, how can i simplify this beacuse I really think i'm doing this wrong!!!

What i need is to see all records if no filters are on, then see records based on whichever filters are being used, with the understand there ISNT always data in that field in every record!!!

[June7]

I NEVER use dynamic parameterized queries. I prefer http://www.allenbrowne.com/ser-62.html

[Perceptus]

you could simplify by using a make table query based on the underlying query. And then filter the newly created table with a 2nd query.

or you could simplify with making subqueries and what not. If it makes sense to you and you can explain it to the next guy, thats good enough for me =).

[gangel]

thanks ppl

June7 that was above my brain level last time you mentioned it but i think ill have a look now and get it working that way.

Percept, ill use the subquery method as a fall back. If i can master the sql a bit better and learn from this code then all the better

Thanks pplz!~