I have a union query that I want to sort using the following:
IIf([cboEstimateStatus]="Incomplete",1,IIf([cboEstimateStatus]="Returned",2,IIf([cboEstimateStatus]="Pending Request",3,4))) AS Status
ORDER BY IIf([cboEstimateStatus]="Incomplete",1,IIf([cboEstimateStatus]="Returned",2,IIf([cboEstimateStatus]="Pending Request",3,4)))
These are the main statuses and I want these to be on top but I also want to add another field which would be project number. How can I modify this to add [txtProjectNumber] to the sort?
The output would look like: