How to add a sort field to a query?

[Gezza]

Hi,
I have data in a table that I need to sort in a specific order, and it is not alphabetical or numeric, can I add a field in a query to add a set of values that I can use to sort by? hope this is clear enough

 

[boblarson]

Can you give a bit more data like an example of the data you are looking to do? What do you need to sort by? If you need a specific sort, you may need to add a field in which you can put the order of the records.

 

[Gezza]

The data is in a date but is set as text because some of the data is grouped by year some by month and then some by week. the data needs to be sorted first by year then last 12 months then last 4 weeks then the next three months. sort by date doesnt work nor by alphabet I think I need to add a new field to put in a data set that I can sort by. there is a fuction in excel called FILL that would do what i need but I dont know if it is available in access