week number as date

G

Guest

heI have converted dates to week number in a preceding query, then in a
Crosstab query grouped by week number.
In the report based on teh crosstab query I would like to show the Week
commencing date. I would prefer not to add extra fields to the crosstab
query, can I do it direct in the report?
 
G

Guest

This will display the week of the year and the week date. To adjust which
day of the week you will display as the "Week commencing date" change the
number in the formula. The '+2' put the Monday date.

Format([YourDate],"ww") & " - " & [YourDate]-Format([z],"w")+2
 
G

Guest

Not sure I'm following this. What is the [z]?

KARL DEWEY said:
This will display the week of the year and the week date. To adjust which
day of the week you will display as the "Week commencing date" change the
number in the formula. The '+2' put the Monday date.

Format([YourDate],"ww") & " - " & [YourDate]-Format([z],"w")+2


steph said:
heI have converted dates to week number in a preceding query, then in a
Crosstab query grouped by week number.
In the report based on teh crosstab query I would like to show the Week
commencing date. I would prefer not to add extra fields to the crosstab
query, can I do it direct in the report?
Click to expand...
Click to expand...
 

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

MS Access Query Design Question 0
Week Number 2
Get date for start of week 3
Crosstab Date Range in Reports 3
dynamic columns number in crosstab report 4
Calculating % Change 3
report based on crosstab 2
Crosstab Query and Date Parameters 10

Top