How do I use same date parameters for different queries and report

[Guest]

I'm having the same problem as Gavelle described below.

That is: I've followed the advice and set up a form to have my queries and
reports pick the dates from the form. But the queries/reports are still
asking me to
enter the beginning and ending date parameters for each query/report.

Also, when i set up the form it runs the query correctly. But when i try to
run the query (or report based off the query) I only get a general parameter
box stating Enter Parameter Value "forms!FORMNAME!StartDate and another for
the end date. Everything in my query criteria is typed correctly but
something must be wrong... Any suggestions please?

Steve


Previous questions/answer below:

Subject: RE: How do I use same date parameters for different queries in 1 r
2/23/2007 2:11 PM PST

By: Gavelle In: microsoft.public.access.reports


Damian S - Two issues, i'm hoping that you can help!

I'm having the same problem as ccb. I've followed your advice and set up a
form to have my query pick the dates from. The report still is asking me to
enter the beginning and ending date parameters for each query/sub-report.

Also, when i set up the form it runs the query correctly. But when i try to
run the query (or report based off the query) i only get a general parameter
box stating Enter Parameter Value "forms!FORMNAME!StartDate and another for
the end date. Everything in my query criteria is typed correctly but
something must be wrong... Any suggestions?

 

[Allen Browne]

The query (and so any report based on the query) will read the dates from
the form provided:
a) The form is open.
b) There are values in the date boxes.
c) You spell the form name and text box names correctly in your query.

The query may get the dates wrong if any of these apply:
A) You have not left the cursor in the date boxes (in which case the Value
may not yet be updated.)
B) The text boxes on the form are unbound, and you did not set their Format
property to one of the date formats (e.g. General Date.)
C) You did not declare the parameters in your query (Parameters on Query
menu in query design.)

More about that:
http://allenbrowne.com/ser-36.html