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").
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

crosstab query? 12
Help with generating week dates for a table. 2
Extract data by week numbers for rolling 10 weeks 2
Crosstab Query by Week with Dates as Headers 5
Numbering....??? 4
Need Monday date for given week number 4
Week number to Monday of week 3
Week Numbers 1

Back
Top