Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 1 / February 2006

Tip: Looking for answers? Try searching our database.

A2K3: Problem with displaying week number on report

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jnikle@gmail.com - 17 Feb 2006 16:12 GMT
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
Fred Zuckerman - 17 Feb 2006 16:33 GMT
> I'm stumped on this one.
>
[quoted text clipped - 11 lines]
>
> -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
Wayne Gillespie - 17 Feb 2006 17:37 GMT
>I'm stumped on this one.
>
[quoted text clipped - 11 lines]
>
>-Josh Nikle

"Week " & Format([MyField],"ww")

Wayne Gillespie
Gosford NSW Australia
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.