Date

[nl]

In a query or report, where there's a date field, in that
field is a list of date for a record, and the a record has
differents dates, how can I show only the first date for
that record?

Example: Record 1 Date
tel 06/01/04
tel 06/02/04
mes 06/02/04
mes 06/05/04
I want only to show the record name and the first date in
order for that record. (tel 06/01/204 mes 06/02/04)

thank you.

 

[Jim/Chris]

You might want to put min rather than first in case the
records were added in random order.

Jim

-----Original Message-----
Do a totals query on that table and do a Group by on the

Name field and a First of on the date field.

 

[Guest]

Sorry, I meant to put "min". Thanks for the catch.