Help with Ascending Order sort

[Lucieann]

I am trying to sort records by their category number (i.e. 225-1, 225-2, 225-3,...). However, 225-10 prints before 225-2. How can I keep this from happening?

Thanks!

 

[pgtek]

Hi

it's your database table that cause that.
ask your dba to fix it

cheers



pgtek

 

[Lucieann]

The records are not in the database that way. I have a formula that adds the -1, -2, ... to the main category number. In the database, they are actually two separate fields.

 

[Lucieann]

I figured it out. I had my sort criteria set to sort by the formula instead of the two separate fields.