Group & Sort Single Field in Query (1 Viewer)

I have a query with all the data I want in it.
I want it grouped by ProjectType, then FundingType, then sorted by ProjectPriority, which is how it is set up currently.
The problem I have is, the ProjectPriority can be a number "01, 02, 03, etc" prioritizing the projects or it can be "OBL" when the funding is Obligated (Awarded).
I would like to group all the "OBL" at the top or bottom of query.
The ProjectPriority field in the table is a short text field.

Can anyone help me out with this?
See two snap shots attached showing the query.
Thank you.

Hi. You could try something like:
Hope it helps...

Yes. Thanks!
Here's what I ended up with in the SQL


Thanks for the help.

Weekleyba said:

Yes. Thanks!
Here's what I ended up with in the SQL

Code:Copy to clipboard

ORDER BY [1ProjectT].ProjectPriority="OBL" DESC

Thanks for the help.

Click to expand...

Hi. You're welcome. Glad to hear you got it sorted out. Good luck with your project.