Find table entries
I have a master table (tblVisit) on each visit someone marks down whether
they found a specific item or action point.
If for example they found a health and safety issue 3 times within any 12
week period how can I write a query to that effect?
Data Looks Like this:
VisitID | DateServiceStart | VisitActivityRef |
111 | 01/01/2013 | 1
222 | 01/02/2013 | 1
333 | 06/02/2013 | 2
444 | 23/02/2013 | 1
555 | 18/03/2013 | 2
Many thanks for your help.
No comments:
Post a Comment