Using BETWEEN in ACCESS Query, how can I label the Week Number?

[tol514]

I have a huge file. One of the fields is FROM DATE, or [DATE]. How can I code a Query expression that would say, for example, IIF [DATE} BETWEEN X AND Y, then label this field 9 - where 9 is the week of the year? Or is there an easier way? I have to create a field, through ACCESS Query,that would hold the week number, so that I can transfer the file to XLS and to Payroll.

Tom Walsh, HRIS Analyst
Capital Health System
ADP HR&Payroll wi RSmith

 

[SkipVought]

Hi,

First I would change your Field Name, as Date is a reserve word in many MS applications.

How are you defining Week of Year, with respect to what? My Week of Year may start on a differnt day than your Week of Year start.



Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[MichaelRed]

see the ubiquitous "Help" (aka "F1") for DatePart.

? DatePart("ww", Date())
50

'Date being 12/11/2008

'Be SURE to read through the help AND review the info on the arguments.



MichaelRed

 

[tol514]

Thank, Michael - the DataPart Function did it!! I like your use of those splendid words, too! Tom

Tom Walsh, HRIS Analyst
Capital Health System
ADP HR&Payroll wi RSmith