By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,486 Members | 1,660 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,486 IT Pros & Developers. It's quick & easy.

A2K3: Problem with displaying week number on report

P: n/a
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

Feb 17 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
<jn****@gmail.com> wrote in message
news:11*********************@z14g2000cwz.googlegro ups.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
Feb 17 '06 #2

P: n/a
On 17 Feb 2006 08:12:42 -0800, jn****@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
Feb 17 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.