Date Range in a Report

[Guest]

Hello,

I would like to print a report for a specific date range. I have many
queries which are subreports in my main report. In these queries there is
criteria of "start & end date" so when I run a query I get information from
that specific date range. However, when I run my main report incorrect
information shows up and I have to repeatedly type in the "start & end
dates".

Is there something else that I could try? Thanks.

 

[Guest]

Try this:

-Create a form with 2 text boxes, one for start date and one for end date
(MyForm)
-In all your related queries' criteria replace the [Start Date] and [End
Date] with
between Forms!MyForm![Start_Date] and Forms!MyForm![Start_Date], you can use
the build option in the toolbar for help (...\ Icon)
-Leave that form open when opening the report

this will take care of the multiple prompt of the parameters, and will help
you review one by one your queries' results

 

[Guest]

I tried this......but my main report still shows no information. Any other
ideas?

Thanks

Try this:

-Create a form with 2 text boxes, one for start date and one for end date
(MyForm)
-In all your related queries' criteria replace the [Start Date] and [End
Date] with
between Forms!MyForm![Start_Date] and Forms!MyForm![Start_Date], you can use
the build option in the toolbar for help (...\ Icon)
-Leave that form open when opening the report

this will take care of the multiple prompt of the parameters, and will help
you review one by one your queries' results

--
jl5000
<a href="http://www.joshdev.com"></a>

Hello,

I would like to print a report for a specific date range. I have many
queries which are subreports in my main report. In these queries there is
criteria of "start & end date" so when I run a query I get information from
that specific date range. However, when I run my main report incorrect
information shows up and I have to repeatedly type in the "start & end
dates".

Is there something else that I could try? Thanks.