Report with many subreports - filter by date?

[s07civic]

Hi, I am working on a database for a community health center to track patient measurements and demographics for grant requesting.

I have a report (based on some queries) that shows the count of each patient within each category for the demographics.

However, is there a way to limit the results of the query by patient intake date? Using a parameter query? (Patient intake date is located in the Patients table).

I attached some pictures. 1=a piece of the report, 2=an example query that I used to make the report (by dragging them in).

Thanks in advance for any help you can provide!

 

[GinaWhipp]

Are you going to use a Form or do you just want the query to prompt you prior to running?

 

[s07civic]

Hi Gina,

The only way I am familiar with is having a query prompt the user, but then the user would be prompted ~30 times for the same information.

If I used a form to ask for the date range could the form handle that, then spit out the report?

Also, I can attach the accdb if that might help?

Thanks a lot!
Scott

 

[GinaWhipp]

I don't need a sample was just asking which way you were planning. I see by your answer a Form would work best. Have a look at...

http://allenbrowne.com/ser-62.html

Code can be modified to spit out a Report instead of showing results in Form.