how do I query daily records by week?

H

halfshoe

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

Extract data from previous week, previous two weeks, etc. 2
Group by week 3
Week, monthly, quarterly 2
I require a query to count repairs by week 4
Fiscal Year Week Number Calculation with a twist.... 6
Make the query work out the date inputs automatically? 2
Crosstab Query by Week with Dates as Headers 5
Return multiple records from a single entry. 2

Top