MS Access database support - Re: Problem with displaying week number on report

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: Problem with displaying week number on report

Fred Zuckerman

2006-02-17, 11:24 am

<jnikle@gmail.com> wrote in message
news:1140192762.472243.10150@z14g2000cwz.googlegroups.com...
> I'm stumped on this one.
>
> I have a report that shows production calculations for a user-selected
> period divided up into weeks. Currently, I just use
> format([MyField],"ww") to get the calendar week for the purposes of
> grouping the data. However, my users would rather that I display the
> number of the week in the period they've selected. If, for instance,
> they select 2/1/2006 to 2/28/2006, they want to see "Week 1," "Week 2,"
> "Week 3," etc. rather than the actual calendar weeks of 5, 6, 7, and 8.
> Hope that makes sense.
>
> Any ideas how I'd go about doing this? Thanks in advance for any
> suggestions.
>
> -Josh Nikle

If you set a variable equal to the first date (dt1 = #2/1/2006#)
then use

Format([MyField],"ww") - Format(dt1,"ww") + 1

Hope That Helps,
Fred Zuckerman

Sponsored Links