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

C

cocobear214

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?
 
D

Damian S

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.
 
G

Gavelle

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Parameter Query of "between ...and " 1
Reference controls on a dialogue form as the parameters 2
How do I use same date parameters for different queries and report 1
Pulling date from parameter 2
print a date range from parameter query on a report header? 2
Can a report be generated based on a parameter query? 6
Date Range in Reports 2

Top