Change week number

[ToddL]

I would like to make 8/18/2002 as week one, 08/25/2002 week two, etc. Any help would be appreciated.

Thanks

 

[antomack]

I don't know of any easy way other than to set up a table to correlate the actual calendar week to the week you want.

WeekTable
CalYear
CalWeek
ReqYear
ReqWeek

so you'd have something like
2002;34;2002;1
2002;35;2002;2

Then when you want to call your required week number use DatePart("ww",Date()) to find the calendar week which you then use in a query to find your required week number.

The following query would select the required Year and Week for the current date
SELECT WeekTable.ReqYear, WeekTable.ReqWeek FROM WeekTable WHERE (((WeekTable.CalYear)=Year(Date())) AND ((WeekTable.CalWeek)=DatePart("ww",Date())));

 

[ToddL]

Thanks, I will try that.

 

[ToddL]

Maybe I should be a little clearer on what I am trying to do. I have sent out surveys for a study. I would like to create a report that will show me how many surveys have been returned to me (based on a return date that is entered in the computer when surveys come back). I would like 8/18/2002 to be week one and to create a report that will tell me how many surveys were returned in week one, week two, etc. Thanks for your help.

 

[ToddL]

I was able to solve this problem with your help. Thank you