How to Display Query Date Parameters in Report W/O Duplicate pop-u

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

Guest

My query asks Between [From?] and [To?]. When I run the report those queries
pop-up, but don't show up in my report.

When I add a Text Box with ="From? "&[From]&" To "&[To?] - I get duplicate
pop-up boxes when I run the report.

I researched other posts but didn't find something that worked.

Thanks for your help!

John
 
jmuirman said:
My query asks Between [From?] and [To?]. When I run the report those
queries pop-up, but don't show up in my report.

When I add a Text Box with ="From? "&[From]&" To "&[To?] - I get
duplicate pop-up boxes when I run the report.

I researched other posts but didn't find something that worked.
Click to expand...

If the text between the [ ] is EXACTLY the same in the report as in the query
you should not be prompted again.
 
My query asks Between [From?] and [To?]. When I run the report those queries
pop-up, but don't show up in my report.

When I add a Text Box with ="From? "&[From]&" To "&[To?] - I get duplicate
pop-up boxes when I run the report.

I researched other posts but didn't find something that worked.

Thanks for your help!

John
Click to expand...

In an unbound control in the Report Header:
= "From " & [From?] & " To " & [To?]

Note: in your example you did not write the text within the brackets
identically to the query bracketed text.
"[From]" is not the same as "[From?]"
 
Ahh...perfect!

Thanks Rick!

John

Rick Brandt said:
jmuirman said:
My query asks Between [From?] and [To?]. When I run the report those
queries pop-up, but don't show up in my report.

When I add a Text Box with ="From? "&[From]&" To "&[To?] - I get
duplicate pop-up boxes when I run the report.

I researched other posts but didn't find something that worked.
Click to expand...

If the text between the [ ] is EXACTLY the same in the report as in the query
you should not be prompted again.
Click to expand...
 
Back
Top