Converting Table Information

[Guest]

I am stumped on how to accomplish this.....
In our business every week is a week #, so Jan 1-7 is week # 1 and so on to
52(53). I wrote commitments for products by the week numbers, however when I
chart where we are by week and pull in the purchase orders that we actually
made, they are by the date.
So, I thought I could make a table that defined the week numbers (and I did
that) but now what do I do???
I have a table with the "commitments" in it and a table with the week
numbers and what date falls in what week number. Is there a way I can put
the purchase orders by date in and have it convert to the week numbers?
Thank you!

 

[Rick B]

If you have a date field, I believe you can pull the week number out of it
using the DATEPART function. I'm pretty sure WEEK is one of the options.
Check the help files.

No need to build a table for this if you are using standard week numbers.

 

[Ron2005]

me.weeknumber = datepart("w",me.datefieldname)

 

[Douglas J Steele]

Actually, it's DatePart("ww",me.datefieldname)

And there are different interpretations as to what consititutes the 1st week
of the year, so there are a couple of optional parameters that may or may
not be required in addition to that.

 

[Guest]

This helps me- thanks!
I'll do some testing on it

 

[Ron2005]

obviously you are correct. I was working on a project just now using
the "w" and got carried away.

The access help on datepart is a great reminder.

Sorry for the confusion.

Ron