Thanks for your help Rudy,
That query brings back the first record where there are two of the same ids. However, I need to bring back all the records at the same time, just with the duplicates eliminated to show the first entry. Does that make sense?
For simplification, my real query (based on yours) is below:
select tblMonthlyReview.numReviewId
, tblMonthlyReview.numEnquiryID
, tblMonthlyReview.numStatus
, tblMonthlyReview.numMonth
, tblMonthlyReview.numYear
from tblMonthlyReview
where tblMonthlyReview.numyear*100 + tblMonthlyReview.nummonth =
( select min(tblMonthlyReview.numYear*100 + tblMonthlyReview.numMonth)
from tblMonthlyReview
where tblMonthlyReview.numEnquiryID = tblMonthlyReview.numEnquiryID )
_________________________________________________________________ Hotmail messages direct to your mobile phone http://www.msn.co.uk/msnmobile
____ � 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]
