Define a date range for a report - Help

[Optimus_1]

Hello

I want to produce a report from my table data but have the option to select a date range, Am i best to do this using a form?. If so how is it best done.

Thanks
Nat

[SoftwareMatters]

Hello

I want to produce a report from my table data but have the option to select a date range, Am i best to do this using a form?. If so how is it best done.

Thanks
Nat

This is how I would do it:
1. Create a query with the relevant fields in including the date field you want to filter on. The criteria for the date field should target a field on a form. see below

2. Create the report from the query.

3. Create a form called MyForm with a button that opens the report and 2 date fields called Start and End

4. The criteria for the date field will be:

>= [Forms]![MyForm]![Start] And <= [Forms]![MyForm]![End]

[Optimus_1]

Hello,

Thanks for your help, WHat do you mean by criteria?.
sorry for my lack of knowledge

Many thanks

[SoftwareMatters]

WHat do you mean by criteria?.

When you put the query in design view there is a row called criteria.

[Optimus_1]

Aha! should of known that really!. Many thanks, have sorted it.

Thanks Again