Parameters in a Report

[Guest]

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

 

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

 

[Guest]

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

Melinda

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

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