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.

Thanks in advance for all suggestions.