Firing blanks

  • Thread starter Thread starter John
  • Start date Start date
J

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.
 
John said:
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 ?
Click to expand...

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