Sort dates in Crosstab query...

Hello and Help...

I am having trouble sorting dates in a cross tab query...

In my tables, I have time frame for 52 weeks. So for week
1 in the tables, it shows '01 Week' then '02 Week' all the
way to '52 Week).

If I try to sort this time frame in a cross tab query or
any query, it sorts it with '10 Week' first thru '52 Week'
then after that it shows '01 Weeks'.
This messes up how I need it to pull and look on my forms
and report areas.

Am I naming the weeks wrong???
I tried it also the other way ' Week 01', 'Week 02' etc...
and it still does not work...

Please help

You can enter the week column headings into the column headings property and
make sure they are in the order you prefer.

Why would the order in the query make any difference if you are displaying
the results in a form or report?

Are you sure you get '02 Week' and not '2 Week'?

--
Duane Hookom
MS Access MVP
--

"MAXWELL" wrote in message
...
Hello and Help...

I am having trouble sorting dates in a cross tab query...

In my tables, I have time frame for 52 weeks. So for week
1 in the tables, it shows '01 Week' then '02 Week' all the
way to '52 Week).

If I try to sort this time frame in a cross tab query or
any query, it sorts it with '10 Week' first thru '52 Week'
then after that it shows '01 Weeks'.
This messes up how I need it to pull and look on my forms
and report areas.

Am I naming the weeks wrong???
I tried it also the other way ' Week 01', 'Week 02' etc...
and it still does not work...

Please help