Query sort order question
Posted on 1998-07-31
Hope someone can help.
I want to define a specific sort order a query will return on a Paradox table.
The field that I'm trying to sort(correctly) is the day field i.e Monday, Tuesday....Sunday.
I have a table which hold staff accident records, the index is auto-increment and I don't want to change the table structure. I can set the query to Order By ...and it sorts no problem, but of course it sorts alphabetically which is of no use in this instance.
The sort turns out as Friday, Monday,Thursday etc, I really need the sort to be the logical Monday, Tuesday, Wednesday....
Anyone know how to do this ?
Thanks in advance