Ordering My Header in a Report

[Lrap]

I want to order my report by my month field. I only have the month to input so the data type is in text. I can't get it to order in the correct month, right now it's april, june, may. It's ordering by alphabetical. How can I get the header to order it by April, May, June. Ordering in the table view doesn't matter the report just orders it by alphabetical letter.

[ItsMe]

......the data type is in text.

I would focus on this information right here.

Is there an explanation why this is the case?

[Lrap]

All I have is the Month, you can't just put just the month in Date/time data type, need day and year which I don't have.

[ItsMe]

There is more than one way to go about it. My preferred method is to create a table dedicated to something I want in a specific order. In this case, it would be a table with two columns. One column is the primary key and the other column is the text field to hold each month's name.

In the end this table will only ever have 12 records. You can assign integer as a data type to your table's PK and type in the number for each record that will represent a specific month. There is no need to use AutoNumber in this case.

With that you can sort the PK AtoZ and querry the record using a foreign key value from another table or recordset.

Hope that helps a little. It might not help if you already have a complex DB with lots of info. You can use update queries to fix data and FK firlds.