Report selection forumula

[amfroehlich]

I have made a report but I want to add a selection forumla so that it only selects certain days instead of all items. How do i do that? Also, I have a form where you can enter the month range you want. How can i call the report from that form?

Thanks,

Aaron

 

[SydneyGeek]

Let's say your form has 2 text boxes: StartDate and EndDate.
For illustration, call the form Selector. Do this:

1. Open the query upon which you have based the report, in Design view.
2. In the Criteria row of the date field that you want to filter, type this:
Between Forms![Selector]![StartDate] And Forms![Selector]![EndDate] (change form and control names to suit your setup).
3. Close and save the query.
4. Now, back to the form. In Design view, drag a new Command button onto the form. Make sure that the Control Wizard is (wand icon) is on. A dialog pops up after a few seconds. Follow the prompts, seelcting that you want to open a report in Preview Mode. Choose your report from the list, give the button a caption, exit the wizard and save the form.
5. Now, give it a go

Denis