Sorting a field with Currency and Text

S

simplymidori

Is there a tip on how I can sort this out.

I have a query that outputs as such... I have another key field that sorts
before this currency/text field so that the text actually comes out in order.

But, is there a statement I can write...

If field contains currency to sort at descending?

Apples a 10.00
Apples a 20.00
Apples a 8.00
Apples b Total
Apples c Available
Apples d Remaining

Thanks
 
Top