Using access2000 crosstabs to display in weeks the numbers comes .

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Expr1: Format(DatePart("ww",[DateField]),"00") & " " &
DateAdd("d",-Weekday([DateField])+1,[DateField]) & "-" &
DateAdd("d",-Weekday([DateField])+7,[DateField])
 
Back
Top