Criteria dates in report header 1

[camiller]

I have done this before and cannot remember how, hopefully someone can help. I need to take two criteria dates from a query (between [enter start date] and [enter end date]) and show the two dates entered in the report header. At the moment, when I add the field to the header, I only get the first start date encountered, not my criteria range. Any ideas??

Thanks, C. Miller

 

[randysmid]

Hi,
I use a technique where I have a form used to enter criteria, such as beginning and ending dates. With these field names on the form, it is now possible to place them on the report directly, using the following recordsource for the textbox:
=[Forms]![frmDateRange]![txtDateFrom]
' replace frmDateRange with the name of your form
' replace txtDateFrom with the name of your input date
HTH,
Randy Smith
California Teachers Association