Report Sorting

  • Thread starter Thread starter Sue
  • Start date Start date
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.
 
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
 
Back
Top