Counting New Members per week

[Robin Chapple]

I have a membership table where date of joining is recorded.

I need to count how many joined each week and prepare the result to
show in a graph.

Please advise best method.

Thanks,

Robin Chapple

 

[Ed Robichaud]

One solution is to create a "totals" query. Filter your records by a data
range (i.e. "between #01/01/00# and "01/08/00#") group by date, and count by
memberID.
Use the chart wizard with that query as its data source.

Post back if you need step by step help.
-Ed

 

[Chris Reveille]

Each week of the year has a corresponding number associated
with it. It is a little kooky. The start of the first
week of the year is dependent on you calendar settings. In
my DB the first day of the week(week 1) is Monday so the
first week of the year 2005 starts 12/27/04 and ends
1/1/05. But the last week in 2004 is number Week 53.
12/31/04 is in the 53rd week of 2004.
Hear are some query samples below. I use the the field
[birthdate] for these examples

WeekOfYear: DatePart("ww",[birthdate],1,1)
Full Date Of 1st day of week:
[birthdate]-Weekday([birthdate])+1
full Date of last day of week:
[birthdate]+7-Weekday([birthdate])

then group by WeekOfYear and count People Joined

I suggest experimenting to better understand the above

If anyone can better explain this please help

Chris