Grouping By Week Using a Fixed Start Date

[abinboston]

I have a fixed start date of 06/30/2014


In a table - I have records that are marked complete on certain dates
I need a cumulative query by week based on the start date


the final result will look like below

Week Ending Completed # Cumulative # % of Total

7/4/2014 2 2
7/11/2014 3 5

The fields I have are named StartDate and Completed

I created a query to show only completed records - but I do not know how to group by
the week - using the starting date of 01/30/2014 as the start date



the initial query to select completed records is below

SELECT tblPatients.RecordID, tblPatients.Completed, tblPatients.Completed_dt, qryConfig_StartDate.StartDate
FROM tblPatients, qryConfig_StartDate
WHERE (((tblPatients.Completed)=True));



Thanks

AB

[June7]

1/30/2014 is Wednesday. This will be week 1? Don't want to include Sun, Mon, Tue from December? What are first and last days of your week - Sun and Sat? The records have dates throughout the week?

Options for calculate week group criteria:

1. calculate the week ending date for each record

2. DatePart() function can extract week number: DatePart("ww", [date field])

Then apply the start date in WHERE criteria.

The Cumulative is a running sum? Review https://www.accessforums.net/queries...ery-45841.html