Parameters in a Report

M

Melinda

Good Morning---I have set parameters Between [Beginning Date Work] and
[Ending Date Worked] in the criteria of alot of my queries which works great
and populates that data I need to see when I run the query. I then want to
print the parameters in the report header which I typed ="Between"&[Type
beginning date]&"and"&[Type ending date] so that the dates entered would
print on the report, but it prompts me to enter the beginning date and ending
date twice. I am assuming once from the query and once from the report. I
deleted the criteria in the query, but I then retried a bunch of garbage
dates in the report. I would appreciate any advice.

Thanks
Melinda
 
R

Rick B

You need to use the exact same wording in the query and report. In your
post, you have two different prompts "Beginning Date Work" and "Type
beginning date". You need to use the exact same prompts in both.
 
M

Melinda

Bingo---something so simply, thanks so much Rick.

Melinda

Rick B said:
You need to use the exact same wording in the query and report. In your
post, you have two different prompts "Beginning Date Work" and "Type
beginning date". You need to use the exact same prompts in both.

--
Rick B



Melinda said:
Good Morning---I have set parameters Between [Beginning Date Work] and
[Ending Date Worked] in the criteria of alot of my queries which works
great
and populates that data I need to see when I run the query. I then want
to
print the parameters in the report header which I typed ="Between"&[Type
beginning date]&"and"&[Type ending date] so that the dates entered would
print on the report, but it prompts me to enter the beginning date and
ending
date twice. I am assuming once from the query and once from the report.
I
deleted the criteria in the query, but I then retried a bunch of garbage
dates in the report. I would appreciate any advice.

Thanks
Melinda
 

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

Top