K
KevinT
Hi,
I have a database that includes all accidents drivers have on a date basis.
In the table I have a field for types of accidents, eg pass injury, object
thrown etc.
I wish to run a query to extract the counts of different types of accidents
based on a weekly basis (Sunday to Saturday) from the beginning of the year.
Eg: Dates 31/12/06 - 06/01/07: Count:7 for Pass injury, etc.
TIA & hope I explained it well enough.
Kevin
I have a database that includes all accidents drivers have on a date basis.
In the table I have a field for types of accidents, eg pass injury, object
thrown etc.
I wish to run a query to extract the counts of different types of accidents
based on a weekly basis (Sunday to Saturday) from the beginning of the year.
Eg: Dates 31/12/06 - 06/01/07: Count:7 for Pass injury, etc.
TIA & hope I explained it well enough.
Kevin