Crosstab - column headers by week

S

stepho

How do I make a crosstab query in access with column headers that are for
every Friday? I need to be able to see weekly totals, not monthly.
 
D

Duane Hookom

Is this for a report? Are the weekly column headers going to change over
time?

You can use
ColHead: Format([YourDateField],"yyyy ww")
 
S

stepho

This worked! Thank you! You have no idea how much time you saved me!

Duane Hookom said:
Is this for a report? Are the weekly column headers going to change over
time?

You can use
ColHead: Format([YourDateField],"yyyy ww")

--
Duane Hookom
MS Access MVP
--

stepho said:
How do I make a crosstab query in access with column headers that are for
every Friday? I need to be able to see weekly totals, not monthly.
Click to expand...
Click to expand...
 
Top