Open a report with date range for records or full report?

B

Brook

Good Day All,

I have a report that I currently open using a date range in this format
for my Date on my qrychecking account.

Between [Enter Beginining Statement Date] And [Enter Ending Statement
Date]

The thing is, is that I would like to have the opportunity to open the full
report if I would like without having to enter a date range.

Any ideas?

Thanks,

Brook
 
D

Duane Hookom

You should really consider getting your criteria from controls on a form
rather than parameter prompts. You can always use Nz()
Between Nz([Enter Beginining Statement Date],0) And Nz([Enter Ending
Statement Date],Date()+1000)

This depends on the date range of your date field. You might also be able to
substitute your date field as the second argument of the Nz() function.
 
B

Brook

Thank you very much,

That worked perfectly!

Brook

Allen Browne said:
Use a form where the values can be entered, and if they are not the report
shows all records.

For details of how to do that, see the 2nd method in this article:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Brook said:
Good Day All,

I have a report that I currently open using a date range in this format
for my Date on my qrychecking account.

Between [Enter Beginining Statement Date] And [Enter Ending Statement
Date]

The thing is, is that I would like to have the opportunity to open the
full
report if I would like without having to enter a date range.

Any ideas?

Thanks,

Brook
Click to expand...
Click to expand...
 
Top