Filtering report

[huv123]

I know this is pretty simple but cant work out how to make it all work together.

I know how to filter a report using a form, I know how to create a report that shows counts rather than individual records, but I dont know how to produce a report that shows counts, with the ability to filter the data that is used to produce the counts (according to dates entered into a form).

Right now my access file is a simple table and form setup. A research assistant needs to enter details like whether the person was screened, did they pass the screen and so forth. I want to produce a report that shows for example:

No. of people who did not get screened: ___
No of people who screened but did not pass:___

etc...

Normally I would setup a query based on my table data, with columns such as:

No Screen: Count(if([RecievedScreen]="No",0))

which I would then use as the control source for a text field on the report.


However I would also like to introduce the ability for a person to narrow the period of time that this report represents, by entering the start date and end dates for the period into a form, and then clicking on a button on that form to open the report. The best example of this is here: http://allenbrowne.com/casu-08.html

If you could at the very least describe me the basic setup of this I will hopefully be able to work out what to do.

[alansidman]

If I understand what you are asking, then this may be helpful

http://www.datapigtechnologies.com/f...earchform.html

Alan

[huv123]

Many thanks. I think i was able to work it out and have tested it with some dummy data but it was more trial and error than any specific knowledge. I enjoyed watching this.