Print date range on a report based on a non-date field

[sponge]

Is there a way to show the earliest and latest dates of a report generated by a non-date field?

E.g. I generate a report based on Food, and it'll list the days that this food is associated with. Is there a way to show the first and last day that appears in this report (i.e. the range of dates that the report shows based on the food selected)

 

[RV]

Your topic titl seems rather misleading

Apparently, your report shows a date.
Create two unbound control boxes in the report header.
For the first one, use this as the Control Source:

= DMin("columnname","queryname")

and for the second one:

= DMax("columnname","queryname")

Replace columname with your column name representing the date field in your report.
Replace queryname with the name of the source on which your report is based.

RV

 

[sponge]

Yep, my report's got a date field on it!

Works like a charm

Thanks!