Sorting on another field

[BlurredVision]

I searched the forum without any luck. So, looking for a little help.

I have the following data:

FIELD1 FIELD2

IDK
FAC Primary
SLA
AKS
SLS Primary

I am looking to list out the data by it's name, with primary being first. I know I could group it by FIELD2 than by the FIELD1, but I would rather use a formula.

Thank you for any help given

BTW: CR XI on SQL 7 DB

 

[lbass]

So which field is the name field? How would you expect the above data to look?

-LB

 

[BlurredVision]

Sorry about that.

The results should mirror the following. FIELD1 is the name field.

FIELD1 FIELD2

FAC PRIMARY
SLS PRIMARY
AKS
IDK
SLA

 

[lbass]

You just have to sort descending on field2.

-LB