One question on designing a calculated control in an Access report

[Dave]

Here is what I want to do: In a group footer in a report, I want to
include a calculated control that will display the number of days
between the date of the first record in that group, and the date of the
last record in that group.

Simplest way to do this would be appreciated. Thanks in advance for any
assistance.

Dave

 

[John Vinson]

Here is what I want to do: In a group footer in a report, I want to
include a calculated control that will display the number of days
between the date of the first record in that group, and the date of the
last record in that group.

Try:

DateDiff("d", Min([datefield]), Max([datefield]))

 

[Dave]

John,

Thanks!! That did the trick! I really appreciate it.
Dave

Here is what I want to do: In a group footer in a report, I want to
include a calculated control that will display the number of days
between the date of the first record in that group, and the date of the
last record in that group.

Try:

DateDiff("d", Min([datefield]), Max([datefield]))