Month display

[geno]

Hi, my problem is that the months on my axis show up sorted, so instead of starting at Jan, Feb etc. it is sorted as Apr, Aug etc.
Is there a way to show the months properly?
Thanks

 

[RedSkies]

It sounds like you're using text fields to store month names, yes? You might want to consider converting them to Date data type. Then to format them to show only the month name use the following:

Me!TheDate = Format(Me!TheDate, "mmm")

Then Access will order them properly.

Another option is to store month names in a lookup table with a numeric ID field, and the month name text field (1, January; 2, February; etc.) Then you can always order them by ID number.

Hope that's what you're looking for.