Hi,
Apologies if I have listed this incorrectly, it is my first question on the forum.  

The problem:
Generate a report which shows only shifts which are in breach of the users allocation limit for shifts per week.

The data:
id | shift_type | date | user_id

The logic:
Users can only do 3 shift_type "graveyard" per week.

For each user ID i want to check the number of "graveyard" shifts they have done per week and if this exceeds 3 then I want to display the shifts (id, shift_type, date, user_id).

I think I may need a combination of the Select and Loop functions neither of which I have used before.


Cheers,

bowja 

If you are using a date criteria to only pull the data for a specified week, you can do the following: