Help on Numbering by week

[Lou]

Hello!

I have a [DateReceived] field in my report which sorts by
the week. I have a date range criteria set up for the
report so it reports 8 weeks at a time.

I need a formula for a field which will tell me "Week
1","Week 2" and so forth up to week 8. How do you folks
suggest this..?

Thank you.
Lou

 

[Fons Ponsioen]

You can use the Weeknum function to determine teh current
week and use a calulation from this to determine the date
and project the future or past 8 weeeks. You may need to
install msowcf.dll.

WEEKNUM(serial_num,return_type)

Return_type could be left blank which would start the new
week on Sunday and end it on Saturday.
Hope this helps.
FOns

 

[Lou]

Hello FOns!

Thank you for the information. I was not able to get it to
work the way I wanted to. I have a date control which
gives me the week of the year, I think I need a formula to
recognize the date and then assign a value to emty cell
which is 1 thru 8 "earliest to lastest". I hope this makes
sense..If I am not interpreting you response correctly
please let me know.

Thank you.
Lou

-----Original Message-----
You can use the Weeknum function to determine teh current
week and use a calulation from this to determine the date
and project the future or past 8 weeeks. You may need to
install msowcf.dll.

WEEKNUM(serial_num,return_type)

Return_type could be left blank which would start the new
week on Sunday and end it on Saturday.
Hope this helps.
FOns

-----Original Message-----
Hello!

I have a [DateReceived] field in my report which sorts by
the week. I have a date range criteria set up for the
report so it reports 8 weeks at a time.

I need a formula for a field which will tell me "Week
1","Week 2" and so forth up to week 8. How do you folks
suggest this..?

Thank you.
Lou
.

.