Week not sorted correctly

[Kevin Labore]

I am sure there is a simple solution to this
I have a query that has "Week: Format([Date],"ww")"
and then it groups by , ascending order.

The problem is that it apparently assumes its a text value rather than
numeric and the results would be (1,10,11 ....2,20,21, etc) I want to get
(1,2,3,4,etc) for a result. I suppose I could sort by date and then let the
report sort/group by week but I would rather do it in the query.

What do I need to do this in the query?

thanks

Kevin

 

[Tom Ellison]

Dear Kevin:

Format will always return a string. To return an integer, look at the
DatePart function instead.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts

 

[Kevin Labore]

Thanks for the help Datepart is what I wanted I forgot about the difference

Kevin

Dear Kevin:

Format will always return a string. To return an integer, look at the
DatePart function instead.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts

I am sure there is a simple solution to this
I have a query that has "Week: Format([Date],"ww")"
and then it groups by , ascending order.

The problem is that it apparently assumes its a text value rather than
numeric and the results would be (1,10,11 ....2,20,21, etc) I want to get
(1,2,3,4,etc) for a result. I suppose I could sort by date and then let the
report sort/group by week but I would rather do it in the query.

What do I need to do this in the query?

thanks

Kevin