Firing blanks

[John]

Hi

Is there a way to sort a column ASC or DESC and have nulls in that column
always at the bottom of the results ?

eg.

Abacus
Bridge
Truck
Xylophone
<null>
<null>

or

Xylophone
Truck
Bridge
Abacus
<null>
<null>

Straightforward ASC always shows blanks at the top. I'm using Access/Jet.

Any help gratefully received.

 

[Rick Brandt]

Hi

Is there a way to sort a column ASC or DESC and have nulls in that column
always at the bottom of the results ?

Sort on the expression: Nz([YourField], "ZZZZZ")

 

[John]

Great thanks Rick.

Is there a way to sort a column ASC or DESC and have nulls in that column
always at the bottom of the results ?

Sort on the expression: Nz([YourField], "ZZZZZ")