> What I need to do is bring back only the first entry for that clientID,
> for each clientID, and I need to use only SQL to do it.
select uniqueID
, clientID
, status
, Xmonth
, Xyear
from yourtable ZZ
where Xyear*100+Xmonth =
( select min(Xyear*100+Xmonth)
from yourtable ZZ
where clientID = ZZ.clientID )
i used column names Xyear and Xmonth because year and month are reserved
words
you may need [year] and [month] in Access
rudy
http://rudy.ca/
____ • The WDVL Discussion List from WDVL.COM • ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED]
Send Your Posts To: [EMAIL PROTECTED]
To set a personal password send an email to [EMAIL PROTECTED] with the words: "set
WDVLTALK pw=yourpassword" in the body of the email.
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
