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

[jmuirman]

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

 

[Rick Brandt]

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.

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

 

[fredg]

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

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?]"

 

[jmuirman]

Ahh...perfect!

Thanks Rick!

John

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.

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