help with MIN function 1

[georgia51390]

Hi there,
I have a table of patient IDs and appointment dates. Patients may be in the table a number of times with different appointment dates. I need to create a new table with each patient ID only once and their EARLIEST appointment date. Is that possible with the MIN function?
Thank you!

 

[tlbroadbent]

Yes. Just Select MIN(ApptDate) to get the earliest date in the table. Use group by on PatientID to get the earliest date per patient.

Select PatientID, MIN(ApptDate)
From table
Group By PatientID

NOTE: This works if the ApptDate field is datetime data type. If you've stored dates as text, it may not work without converting the date to datetime. Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it and comment if you have time.
NOTE: Reference to the FAQ is part of my signature and is not directed at any individual.