Sort with blank rows at bottom

[Rauken]

I have a query and I have the abilitiy to sort that query on three fields. Some of the records might not have data in all three field e.g.:

column1 column2 column3
1 23 3
3 12 2
1 43

If I sort ascending on column3, row no 3 will show up first becuase it's blank. I want it to be at the end instead but the other two sorted ascended way.

This should be a quite common problem I guess?

 

[KenReay]

Hi

Try ORDER BY Nz(Col1,99999999999)

assuming the column to sort on is called Col1, and it is a numberic type

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Rauken]

Sorry I want to sort on Column3.

 

[Rauken]

Oh sorry I missed the Nz function