Sorting by Week and Year

[sq75222]

I have a problem on the soting by week, when i convert date to week ( "ww
YY") and sort as ascending the results is not i want see as below.

Week : 1 08,10 08,11 08,...,2 08,20 08,21 08,.... ( after sorting)

but I need to show as

Week : 1 08,2 08,3 08,4 08,..,10 08,11 08,12 08,...,20 08,21 08,....52 08.

 

[John Spencer]

Try changing your expression to
Format(DatePart("ww",YourDateField)"00 ") & Format(YourDateField,"yy")

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[orange]

I have a problem on the soting by week, when i convert date to week ( "ww
YY") and sort as ascending the results is not i want see as below.

Week : 1 08,10 08,11 08,...,2 08,20 08,21 08,.... ( after sorting)

but I need to show as

Week : 1 08,2 08,3 08,4 08,..,10 08,11 08,12 08,...,20 08,21 08,....52 08.

It appears you are getting a character sort, you need a numeric sort.

 

[sq75222]

thk, it work. but the exp should be Format(DatePart("ww",YourDateField),"00
") & Format(YourDateField,"yy")