|
Home > Archive > MS Access database support > February 2006 > A2K3: 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 |
A2K3: Problem with displaying week number on report
|
|
| jnikle@gmail.com 2006-02-17, 11:24 am |
| 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
| |
| Wayne Gillespie 2006-02-17, 1:24 pm |
| On 17 Feb 2006 08:12:42 -0800, jnikle@gmail.com wrote:
>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
"Week " & Format([MyField],"ww")
Wayne Gillespie
Gosford NSW Australia
|
|
|
|
|