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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
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?
 
Back
Top