I am looking to create a report from a large table, that shows the number of instances of a certain criteria on a weekly basis - grouped in 7 day buckets - over the course of an entire year.
Is a report the best place to start this? Maybe start with a query first that creates the "buckets"?
Any ideas as to how I could accomplish this would be appreciated.
Is a report the best place to start this? Maybe start with a query first that creates the "buckets"?
Any ideas as to how I could accomplish this would be appreciated.