How do I use same date parameters for different queries in 1 repo.

[Guest]

I'm trying to create a report of several queries that require dates as
parameters. However, when I set the query to ask for the dates, it asks it
for everyone of the queries on the same report. A single answer for the date
is suffiicient for all the queries. How do I set this up?

 

[Guest]

Hi ccb,

Use a form that has two date fields on it, then have your queries pick the
dates up off the form instead of prompting, like this:

between forms!FORMNAME.STARTDATE and forms!FORMNAME.ENDDATE

Hope this helps.

Damian.

 

[Guest]

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?