Report Sorting

S

Sue

I ran one report and it should be sorted by monthly. The
problem I have is as following. My month was entered like
1, 2, 3, 4,...(for Jan, Feb, March...). When I ran the
report, 10 (which is October) is alwasy following 1, then
2, 3. That is very confusing. I need to ran a report that
is Month 1, 2, 3, 4, 5, 6, 8, 9, 10, 11, 12 instead of 1,
10, 11, 12, 2, 3... Thank you for your help.
 
G

Graeme Richardson

Hi Sue, the month is being sorted as text (hence 1, 10, 11, 12, 2, 3 ...).
Convert it to number and sort by that expression:

i.e., In the sorting / grouping dialog, add the expression:

=CInt([month])

where [month] is then name of the field containing the month number

Hope this helps, Graeme
 
Top