Order by without blanks

[bodylojohn]

Hello,

I have the following row:

Name
-------

Zack
Peter

Quintin

John
Brad

As you see it is possible to have a blank space

When I do order by name it looks like this:

Name
----
(blank)
(blank)
(blank)
(blank)
Brad
John
Peter
Quintin
Zack

How can I get this:

Name
----
Brad
John
Peter
Quintin
Zack
(blank)
(blank)
(blank)
(blank)

Thanks for your help

 

[gemma-the-husky]

your query sorts alphabetically, so blanks come at the top

you could have another column something like

iif(nz(targetname,"")="","~",targetname)

- thiis will put the blanks to the bottom (i think ascii for ~ is higher than ordinary letters) - use this column as sort order for your query.