week numbers

  • Thread starter Thread starter vivian
  • Start date Start date
V

vivian

I have a query used in pivot table view that summaries
data by week number. I need to be able to attach dates
to the weeks. How can I do this? eg Week 2 = January 4 -
10, 2004 - I do not know for a fact that is so - I am
making an assumption here - please help me out.
TIA
Vivian
 
See Access VB Help on the DatePart() function (using interval "ww") or the
Format() function (using format "ww").
 
Back
Top