Using access2000 crosstabs to display in weeks the numbers comes .

G

Guest

Using access2000 crosstabs to display in weeks the numbers comes not in order
due to single and double digit. Can i format it so as all appear in double
digit.
Second is there a way to display the date of that week next to it for eg.
week 1 01jan05-07jan05.
This what I have now in my cross tab : Expr1: Format([],"ww").
Many Thanks
 
D

Duane Hookom

Expr1: Format(DatePart("ww",[DateField]),"00") & " " &
DateAdd("d",-Weekday([DateField])+1,[DateField]) & "-" &
DateAdd("d",-Weekday([DateField])+7,[DateField])
 

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

Converting date to Week number 2
How to sort columns in a Crosstab Query 2
week (WW) conversion to date in Access Graph 2
Crosstab Query by Week with Dates as Headers 5
Two digit week numbers in VB 3
crosstab query by week 1
Loop problem when time period loops from 1 to end of period again 3
Change Text format to Numbers format in a query 2

Top