Sort Query Results

[Rogue Programme]

The following is produced by a query i've built....

4a (2007 Jan - Jun)
5a (2008 Jan - Jun)
4b (2007 Jul - Dec
5b (2008 Jul - Dec)

I need it in numerical order not alphabetical so it looks like this:

4a (2007 Jan - Jun)
4b (2007 Jul - Dec
5a (2008 Jan - Jun)
5b (2008 Jul - Dec)

Any ideas

 

[MStef]

Look at "DemoSortQryResultsA2000.mdb", (attachment).
I think it is what you need.

 

[Rogue Programme]

Sorry, i can't open it, i'm using Access 97.....

 

[MStef]

OK, here it is.

 

[Rogue Programme]

OK, here it is.

Brilliant, thankyou.

 

[gemma-the-husky]

i dont understand - did you set out the problem wrongly

- the initial sort is not alphabetical , unelss the numbers and letters are in different columns

4a (2007 Jan - Jun)
5a (2008 Jan - Jun)
4b (2007 Jul - Dec
5b (2008 Jul - Dec)