Can I print only the lastest time from a group of times?

[pokerace]

How would I be able to get Crystal to only show the latest times from a list of times? For example, if my query pulls five times (10am, 11am, 1pm, 2pm, 3pm) how would I then query only he latest time?

 

[lbass]

Go to report->selection formulas->GROUP and enter:

{table.time} = maximum({table.time})

This would display the record(s) with the latest time in the report. If you want it per group, then use:

{table.time} = maximum({table.time},{table.group})

This will give you the latest time for the day or across days, e.g., the closest to midnight. I wonder if that's really what you are looking for?

-LB

 

[pokerace]

I think that will do the trick. I just want to show the latest time record for my database {table.stoptime} field. However, I first grouping by last name and then first name, so I guess if I apply that second formula to the inner most group (first name) it should work.

Thanks.

 

[lbass]

The second formula would then give you the latest time for the person.

-LB