Query Sort Order

[zp162002]

I need to change the sort order of a query so letters sort after numbers. Any suggestions on how to do this? Thank you.

 

[GKProgrammer]

Well if you don't care if the Letters are sorted from Z-A instead of A-Z then you can sort them in descending order.

Regards,
gkprogrammer

 

[zevw]

Try this!

create a new column in your query expresion called

CharVal: IIF(ISNUMERIC([FieldName])=True, [FieldName,0)

Sort By this Column you will get your characters before the Numbers.

 

[GKProgrammer]

zevw,

That will force the numbered fields to be sorted on the bottom but it will leave all of the fields that begin with letters to be unsorted on top. Do you have a way to include a sort for these fields as well not just the numbered fields?

Regards,
gkprogrammer

 

[zevw]

Sort by the field CharVal First and then by the Column with characters second