Latest Date

[Tyler]

In the example given below, you will have to group on the
Co field and use the max function for the date field.

Both the groupby and max functions can be found in the
total line of the query design window.