J
JoeAccess381
I am new to building databases. My boss wants me to track records by week.
In Access 2002, it automatically will break it down for you by week if you
want it. However, I only have Access 2000 at work and all I get are the date
field listed by individual days when I set up my Pivot table. To have to
manually add in a column and enter that piece of data manually would be a
pain.
I can't figure out how to write the expression in the query or form in 2000
to make the database give me the corresponding serial week number to the Date
entered so that I can set up my Pivot Table correctly.
i.e. 8/4/04 = Week 32
I was given WeekNumber
atePart("ww",[DateField]) as a solution, but it
keeps telling me that there is a incorrect dot or !
All help is appreciated...
Joe
In Access 2002, it automatically will break it down for you by week if you
want it. However, I only have Access 2000 at work and all I get are the date
field listed by individual days when I set up my Pivot table. To have to
manually add in a column and enter that piece of data manually would be a
pain.
I can't figure out how to write the expression in the query or form in 2000
to make the database give me the corresponding serial week number to the Date
entered so that I can set up my Pivot Table correctly.
i.e. 8/4/04 = Week 32
I was given WeekNumber
atePart("ww",[DateField]) as a solution, but itkeeps telling me that there is a incorrect dot or !
All help is appreciated...
Joe