multiple query reports

[dkirk02]

Ok-let me see if I can explain this....
I have a report with 4 sub reports on it, each one counting the same field on a table, but with different criteria. ie..there are four different types of fruit that I must count. So, I have a separate count query for each type of fruit.
(is there an easier way to do that, btw? count different types of fruit all on one query, when they are in the same field?)
All four queries also have a between date parameter. So, when I put the sub reports on the main report, and then run the main report, it prompts me for a beginning and end date four times, once for each query. Is there a way to only input the date parameter once?

 

[ChristopherM]

In answer to your second question, use a form to input the date(s)and have the query on which the report is based take a runtime parameter from that form eg the Where condition is [Form]![MyForm]![Date]. I'm afraid I cannot think of any easy answer to your first question - if you have four criteria, you are either go to have to enter four times or hard code in to four queries.