I have a query that returns:
[Name] [Event]
Turner Completion
Turner Interim 1
Kemp Completion
Steel Completion
Steel Interim 1
Steel Completion
Steel Interim 1
Webb Completion
Webb Interim 1
Wilkinson Interim 1
what I want to do is where the student has an event of completion in one
row and interim in the other to return completion OR where the student
has one row (one course only)to return either event
Itried doing a group by with a count on event as I can assume that where
two rows exist one is completion. but not sure how to extract the event
description where ther is only one row.
sql so far:
SELECT Qrygetintrimcomplist.Date, Qrygetintrimcomplist.Centre,
Qrygetintrimcomplist.[Course Code], Qrygetintrimcomplist.[Course Name],
Qrygetintrimcomplist.[Last Name], Qrygetintrimcomplist.Event
FROM Qrygetintrimcomplist;
Regards in advance
Peter
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!