Selecting records

[vbgladiator]

Hey,

I have a Schedule table where contacts have appointments.
Sometimes a contact can have more than 1 appointment in 1 day. I want to be able to select all appointments for 1 day but only show the earliest one if a contact has more than 1.

Thanks,

[jhermiz]

Originally posted by vbgladiator
Hey,

I have a Schedule table where contacts have appointments.
Sometimes a contact can have more than 1 appointment in 1 day. I want to be able to select all appointments for 1 day but only show the earliest one if a contact has more than 1.

Thanks,

Huh?

"I want to be able to select all appointments for 1 day but only show the earliest one if a contact has more than 1."

So how is that selecting all appointments?
Do you want one or all ?

Jon