Using access2000 crosstabs to display in weeks the numbers comes .

H

Hasan

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])
 
Top