I need to choose the first record and last record for a string field. 1

[Lucindar]

I have tried to use the max or min function but it gives them to me alphabetically instead of by date. I have sorted the records by date. I am using Crystal 10. I appreciate any help that you can give.

 

[lbass]

If you want the entire record based on the related minimum and maximum dates, then group on the string field, we'll call it {table.string}, and then go to report->selection formula->GROUP and enter:

{table.date} = minimum({table.date},{table.string}) or
{table.date} = maximum({table.date},{table.string})

-LB

 

[Lucindar]

Thanks for your help.... Works great!