query criteria in report header

M

Markitos

Hello, I've looked at other questions and answers but have had no luck. In my
query I have "Between [Enter start date] And [Enter end date]" and I would
like my report header to display the entry in the criteria section. I've
inserted an unbound box and had no luck. I had inserted "= "Between " &&
[Enter Start Date] & " And " & [Enter End Date]" again with no luck. Any help
would be great. Thanks- Mark
 
D

Duane Hookom

Did you try setting your control source to:
= "Between " & [Enter Start Date] & " And " & [Enter End Date]

IMHO, you should consider replacing the parameter prompts with references to
controls on forms. You query criteria would then be something like:
Between Forms!frmDates!txtStartDate And Forms!frmDates!txtEndDate
Your text box on the report would have a control source of:
="Between " & Forms!frmDates!txtStartDate & " And " &
Forms!frmDates!txtEndDate
 

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

Space at end of multi page list to accommodate new entries 1
Using Form for Criteria for Report 3
Displaying a Date Prompt/Criteria in Report Header 2
Use combo to print report between two sets of dates 1
Parameter Values in Report Title 4
Summary Report 3
print a date range from parameter query on a report header? 2
Word does random actions (Mac) 0

Top