Sorting dates (1 Viewer)

[littlej]

I am working on a chart in Access to produce a product by month. I have formatted the date to read chronologically like this: Jan, Feb Mar, Apr, May...and so on. The query works fine. It is the graph that takes the data and sorts it alphabetically...for instance Apr, Aug Dec Feb Jan July Jun. I would like to keep the mmm format. There has to be a simple fix. Can anyone help?

Thanks

 

[Rob.Mills]

Do you actually have a date in this field or does it just have the month's name?

 

[littlej]

I formatted an date using the Format([event_date], "mmm").

 

[Rob.Mills]

Well then if it's a date then use this function instead:

DatePart("m",[Field Name])

This will give you the numeric equivalent of the month and that will sort correctly.

 

[littlej]

I can sort numerically without a problem. I had tried the date part and it works but not the way I needed it to. The graph contains a lot of numbers already and sorting month by number would be confusing. I need the text part.

Thanks for the suggestion though.