May 21, 2008 at 10:23 pm
I have a table has col (Name, ID, WeekNum, ProcDate)
ProcDate is given date: ex: 02/13/08
WeekNum: week 3 of the month in Feb
ID | Name | WeekNum | ProcDate
------|---------|--------------|----------
AG2Z | Jay, Lee | 3 |02/13/2008
JP1D | DJ, Jose | ???? |04/11/2008
PW9U | Tom, CJ | ????? | 05/13/2008
how to do this in a access query? thanks..
May 22, 2008 at 2:43 am
Depending how you define a week number, the 'iso week' function here may help:
http://www.cpearson.com/excel/weeknum.htm
If the vba function does what you want, you could try putting it in an Access code module, then you can call it from an Access query.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy