I am having a problem sorting my table correctly. I would like to get all of my contents in field a in alpha order and all of my contents in fieldb in numeric order as the secondary sort.

I have tried this put the field2 does not sort right.

inde on field1 + alltr(str(field2)) to c:\temp\inde1

It doesn't put the field2 in the right order. Field 2 has positives and negative numbers in it. Does anyone know another way to sort this?

Thanks in advance.