What I hope to learn:
I am looking for an SQL way (in Access) to find the numeric week of the month. In other words 1st, 2nd, 3rd, etc week of the month. The criterion is that the week must be a full week, and must extend to a full 7 days. I have data that must be reported by the week. I will be reporting the number of missed pick-ups per week / per month.
The data I have available:
I have a flat file with individual dates of each missed pick-up.
My attempt so far:
I have created a second file with the date range of each week throughout the remaining year. This is really a small amount of inputing. I have a begining date, end date and a field for the week:
beg_date end_date, week_nr.
I had tried to use a subquery for comparing the range to the actual date of the missed pickup, but I could not make this work.
Any ideas?
Dobe
I am looking for an SQL way (in Access) to find the numeric week of the month. In other words 1st, 2nd, 3rd, etc week of the month. The criterion is that the week must be a full week, and must extend to a full 7 days. I have data that must be reported by the week. I will be reporting the number of missed pick-ups per week / per month.
The data I have available:
I have a flat file with individual dates of each missed pick-up.
My attempt so far:
I have created a second file with the date range of each week throughout the remaining year. This is really a small amount of inputing. I have a begining date, end date and a field for the week:
beg_date end_date, week_nr.
I had tried to use a subquery for comparing the range to the actual date of the missed pickup, but I could not make this work.
Any ideas?
Dobe