Criteria ??

[Lisa MTM]

I have 8 queries that ask for a begin date, end date & plan id, I have them as subreports on one report so when I run, it asks me 8 times, can I put in something so it only asks me once??

 

[pbaldy]

One common solution is to input the date onto a form control, and have all the queries look there.

 

[Ukraine82]

Why do you have 8 queries in a report? Make 1 query for all fields and run it a report.

hth,

Michael

 

[Lisa MTM]

I would LOVE to make one query but I can't figure out how to do it.

I have a trip status field and a trip type field, the queries are based on the different statuses and one is based on status and type. Example...

I am doing a count in each query

Query1 if trip status =S1 or SQ or SR, then if trip type is R, 2 else 1
Query2 if trip status =D*
Query3 if trip status =W*
Query4 if trip status =X5 or X6
Query5 if trip status =XV
Query6 if trip status =XX or XB
Query7 if trip status =X1 or X2 or X3
Query8 if trip status =VN

END RESULT

Query1 15
Query2 6
Query3 11
Query4 18
Query5 2
Query6 4
Query7 1
Query8 21

If anyone knows of an EASIER way I am BEGGING for it.