Date Range Header Issue

[Former Member]

I have a report that dispays several days summarized up for the detail data, without displaying each individual day. When a i create a forumula to show the date range in the header and add it to the header the report adds the detail for each day to the report detail. Is there any way to stop this from happening.

[former_member292966 · Accepted solution]

Hi Michael,

You can use the Minimum and Maximum functions to get your oldest and newest dates like:

ToText (Minimum ({table.DateField}), "MM/dd/yyyy") & " to " & ToText (Maximum({table.DateField}), "MM/dd/yyyy")

This will print something like:

06/01/2009 to 06/15/2009

Good luck,

Brian