how do I query daily records by week?

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.
 
M

Marshall Barton

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Group by week 3
Extract data from previous week, previous two weeks, etc. 2
Week, monthly, quarterly 2
Query records with single Dates Automatically 9
Finding a date for the start date of a week number ("ww") 4
Make the query work out the date inputs automatically? 2
Fiscal Year Week Number Calculation with a twist.... 6
How do I get Monday to be the first day of the week? 1

Top