Date input for query to run report based on dates

J

Jesseb

I need user to type date range for report.
I have a query qryMainGoals.
I have a form frmInputDates.
I have a report rptMainGoals.

When the report is activated I want the frmInputDates to prompt the user for
two date Begin and End.
Then run the query for the report out put based on the dates.

I have the Between [Forms]![frmInputDates]![BeginningDate] and
[Forms]![frmInputDates![EndingDate]

I run the report the form will pop up but the query never gets the date
input. HELP
 
A

AlCamp

Jesse,
I think the last line of your post tells the story...
I run the report the form will pop up but the query never gets the date
input. HELP
Click to expand...

You should open the form first, input your two dates, and while the form is
still open, run the report.

If you run the report first, the underlying query has already run, so the
report can never get the date values.

hth
Al Camp

Jesseb said:
I need user to type date range for report.
I have a query qryMainGoals.
I have a form frmInputDates.
I have a report rptMainGoals.

When the report is activated I want the frmInputDates to prompt the user
for
two date Begin and End.
Then run the query for the report out put based on the dates.

I have the Between [Forms]![frmInputDates]![BeginningDate] and
[Forms]![frmInputDates![EndingDate]

I run the report the form will pop up but the query never gets the date
input. HELP
Click to expand...
 
Top