how do I query daily records by week?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to produce reports for records falling within the 7 day range of each
week. I have queries written where I am promted for a start and finish date
(Monday thru Sunday) and I repeat the query for each weekly period I need. I
would like to query multiple weekly periods at one time. Reports with
multiple weeks would be fiscal month (can be 4 or 5 week), quarters, or year.

I created a table containing a week start and end date (again, Monday thru
Sunday) for all 52 weeks but don't know if it is of any use.
 
halfshoe said:
I need to produce reports for records falling within the 7 day range of each
week. I have queries written where I am promted for a start and finish date
(Monday thru Sunday) and I repeat the query for each weekly period I need. I
would like to query multiple weekly periods at one time. Reports with
multiple weeks would be fiscal month (can be 4 or 5 week), quarters, or year.

I created a table containing a week start and end date (again, Monday thru
Sunday) for all 52 weeks but don't know if it is of any use.
Click to expand...


How about just grouping (View menu - Sorting and Grouping)
the report on the expression =DatePart("w", thedatefield)
 
Back
Top