In a query, I have a large list of records that I need to breakdown and examine for when they occur, by year, month, day of week, and eventually hour of day.
I've identified which records that need to be included with an IIf statement. If it qualifies for examination it recieves a "1" else a "0".
In the report I can group and sort appropriately thanks to Pat, however when I try to determine averages I am getting inappropirate numbers.
What I currently need is the average number of records occuring on specific weekdays per month. Ex: Average Number of Incidents on Fridays in March.
I can sum the number of incidents, but cannot manage to determine the number of times a Weekday occurs in any given month to determine the average.
Any suggestions or ideas would be greatly appreciated.
I've identified which records that need to be included with an IIf statement. If it qualifies for examination it recieves a "1" else a "0".
In the report I can group and sort appropriately thanks to Pat, however when I try to determine averages I am getting inappropirate numbers.
What I currently need is the average number of records occuring on specific weekdays per month. Ex: Average Number of Incidents on Fridays in March.
I can sum the number of incidents, but cannot manage to determine the number of times a Weekday occurs in any given month to determine the average.
Any suggestions or ideas would be greatly appreciated.