K
Kevin11
Does your table have a real date field corresponding to
the Month field. Because the simplist thing would be to
put that actual date field in your Report detail and set
it to Visible: False so you don't see it. Sort by this
field instead and it would sort your months properly.
Otherwise you may have to create a seperate table which
lists the months and what order they should be placed in
and link this table to your primary table via the Month
field. First option is easier.
Hope that helps.
Kevin11
have figured out how to format the query so that it will
sort, by creating a Month ID. But can't figure out how to
use that in the report and hide the numbers.
the Month field. Because the simplist thing would be to
put that actual date field in your Report detail and set
it to Visible: False so you don't see it. Sort by this
field instead and it would sort your months properly.
Otherwise you may have to create a seperate table which
lists the months and what order they should be placed in
and link this table to your primary table via the Month
field. First option is easier.
Hope that helps.
Kevin11
January appears first. Is there a way I can format this? I
have figured out how to format the query so that it will
sort, by creating a Month ID. But can't figure out how to
use that in the report and hide the numbers.