Sorting Months

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am currently working on a Database and most of the work is done. Actually,
not done yet. I have all of the proper information in this database including
the form for that particular database. When I create the report, the easy
part was done. However, when i preview the report, the months are not in
proper order: ie. December, March, June, April, January, etc.. I have tried
to change most of the settings in the database but it won't sort it in the
proper months setting. Can you help me and tell me what I am doing wrong and
I do need a solution bad. I have gone through the discussion site and did try
that, no luck there. What can I do??
 
I am currently working on a Database and most of the work is done. Actually,
not done yet. I have all of the proper information in this database including
the form for that particular database. When I create the report, the easy
part was done. However, when i preview the report, the months are not in
proper order: ie. December, March, June, April, January, etc.. I have tried
to change most of the settings in the database but it won't sort it in the
proper months setting. Can you help me and tell me what I am doing wrong and
I do need a solution bad. I have gone through the discussion site and did try
that, no luck there. What can I do??
Click to expand...

Try including a field in your query

Month([datefield])

This will be a numeric field, 1 for January to 12 for December; use it
for sorting in the Report's Sorting and Grouping dialog. You needn't
display it on the report, but if it's in the query it will help
correct the sort order.

John W. Vinson[MVP]
(no longer chatting for now)
 
Back
Top