Sorting Records With Numbers 1

[jt463]

Does anyone know a way I can get Access to sort records so 10 follows 9 instead of following 1?

My records are:

Cust-1, Cust-2,...,Cust-10

My sort shows:

Cust-1, Cust-10, Cust-2,...,Cust-9

Any help is greatly appreciated.

 

[lespaul]

add to your query:

ORDER BY Val(FieldName)

that may work.


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[PHV]

SQL snippet:
ORDER BY Val(Mid([yourField], 1+InStr([yourField],'-')))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jt463]

Thanks Leslie and PHV.

PHV - your additional code worked perfectly.

Thanks to both of you for your time.