Displaying a Date Prompt/Criteria in Report Header

[Nancy]

I have a report that I set up with a date range prompt (enter beginning date
and ending date) as criteria to limit my data. I would like to display this
date range in the header of my report each time its run so that the date
range is easily identified. I have used a text box for the display of other
fields before, but in this case there is not actually a field name to enter
in the expression. Does anyone know how I would enter the date criteria in
the expression? Following is an example of what I have done in the past for
other text boxes when there is a field name involved, but there is not actual
field name in my date prompt.

=[Field Name]&†“&[Field Name]

Thanks for any light you may be able to shed on this and hope it makes sense.
Nancy

 

[Duane Hookom]

IMO, don't ever use parameter prompts. Use controls on forms for all user
interaction. Then your control source would be:
="Between " & Forms!frmCrit!txtStart & †AND “ & Forms!frmCrit!txtEnd

However, you can use your prompts in the same way you would use a field name:
="Between " & [Enter Start Date] & " and " & [Enter End Date]

If your report doesn't return any records, the second solution will fail
miserably ;-)


However

 

[Nancy]

Thank you! I'll make the changes to my report and query and hopefully it will
work. I appreciate your time.

Nancy

IMO, don't ever use parameter prompts. Use controls on forms for all user
interaction. Then your control source would be:
="Between " & Forms!frmCrit!txtStart & †AND “ & Forms!frmCrit!txtEnd

However, you can use your prompts in the same way you would use a field name:
="Between " & [Enter Start Date] & " and " & [Enter End Date]

If your report doesn't return any records, the second solution will fail
miserably ;-)


However
--
Duane Hookom
Microsoft Access MVP

I have a report that I set up with a date range prompt (enter beginning date
and ending date) as criteria to limit my data. I would like to display this
date range in the header of my report each time its run so that the date
range is easily identified. I have used a text box for the display of other
fields before, but in this case there is not actually a field name to enter
in the expression. Does anyone know how I would enter the date criteria in
the expression? Following is an example of what I have done in the past for
other text boxes when there is a field name involved, but there is not actual
field name in my date prompt.

=[Field Name]&†“&[Field Name]

Thanks for any light you may be able to shed on this and hope it makes sense.
Nancy