I'm hoping you guys can help me with a problem I've got.
I work for a college and have created a db app in Access to track absences.
They want to create a query now to find patterns of absences such as someone who has had 3 consecutive mondays off.
There are two tables one for student details and one for absences. They are linked on a field called StudID. The absences table contains a field called [date] and another called [day] (this is calculated from the date automatically in the forms).
Is it possible to have an SQL statement that will compare all the dates for a particular student and display those who have 3 or more dates exactly 7 days apart?
Could DateDiff be used for this in any way? I'm not an SQL whizz but I do know a bit of vb if necessary.