Sorting Blanks

[WickidWe]

I Have a query that is joining a few queries together
It shows all records for the first query and only the relative for the next 3.


How can I sort based on the second query?
the blanks are always at the top, could I somehow count the blanks as 0 as it is being sorted by numbers anyway?

[June7]

Construct a field in query with expression that converts null to 0 and use that field as sort criteria.

Nz([fieldname],0)