Advanced sorting

[Adele]

Hey all,



I a few thousand records and would like to sort the product code (eight digits long) according to their first five digits only, how would this be done?

Product Code example:

59055009
59055012
60250016
60250015

Many thanks,

Adele

[RuralGuy]

Did you intend to mark this thread as Solved?

[Adele]

yeah sorry ended up using the left function in one column like this:

Product Code: left([product code],5)

and set the 'Total' to 'Where' which hides it then drop another instance in unhidden and its all sorted!

should probly have tried harder before posting for help!

cheers anyway

Adele x

[RuralGuy]

Thanks for posting back with your solution.