Access reports- how do i report within parameters?

[Guest]

Self taught access user needs to know how to create reports to:

show results within a set date paramiter

and also

show results if a radio button isnt selected (i.e. a false rather than true)

 

[Rick B]

You need to modify the query that is used as the record source of your
report.

Open the report in design view and open the properties box. In the "data"
tab, you will find a "records source". To the right of that is a builder
[...] button.

Click it to open the query and modify the criteria to pull the records you
want.

Under the date field, put something like...

Between [Enter Start Date] and [Enter End Date]

Under your other field put something like

False

Then close and save the query.

 

[Allen Browne]

See:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html
for 2 approaches.