Prev: Instr parsing with a comma delimited string
Next: Refering to lowest record in select subquery
From: MCH on 30 Mar 2010 14:20
I have a report that I need to modify so put the oldest and most recent dates
in the header. I want to look at a specific field and find the oldest date
in the report results and also the most recent date in the report results.

I don't know how to do this. Anyone?

thanks, Crockett
From: Darrell Childress on 30 Mar 2010 14:29
Crocket, if I'm understanding you correctly, you would use
Min([YourDateField])
Max([YourDateField])

If you want to put a statement in the header, use something like
="From " & Min([YourDateField]) & " to " & Max([YourDateField])
This will show the range of records shown
Darrell

On 3/30/10 2:20 PM, MCH wrote:
> I have a report that I need to modify so put the oldest and most recent dates
> in the header. I want to look at a specific field and find the oldest date
> in the report results and also the most recent date in the report results.
>
> I don't know how to do this. Anyone?
>
> thanks, Crockett

 | 
Pages: 1
Prev: Instr parsing with a comma delimited string
Next: Refering to lowest record in select subquery