Recent content by jilanis

Yes of course: 1) First query to extract Min attendance date for each caseNumber (group): SELECT Min(tblAttendance.AttendedDate) AS MinOfAttendedDate, tblAttendance.CaseNumber, Min(tblAttendance.AttID) AS MinOfAttID FROM tblAttendance GROUP BY tblAttendance.CaseNumber ORDER BY...

Thank you, your solution works too. But it was very slow and crashed my Access a couple of times but looking at the top records on screen it seemed to be extracting accurate [second attended dates]. It probably because I have got 17,000 records in the tblAttendance. Your solution would work...

OMG it works. Thank you thank you! 1) As per your advice I created a normal query with Min(AttendedDate) and group by on [CaseNumber] (i had to use min(Attid) though just to avoid group by on Attid field). This gives me all the min/first attendance dates for each CaseNumber. 2) I then created an...

Hi guys. I would really appreciate your help on this please. I am using access 2010 and need sql. One table: tblAttendance Attid = unique key casesNumber: text field AttendedDate: Date Each case attends multiple dates. Requirement: I need second attended date for each caseNumber. Note: some...