I have a table that I am trying to use a query to sort by Phone Number.  Some
of the records have no phone number, when I sort ascending it gives me the
records with no phone number first and then the populated ones.  I would like
to have it sorted with the nulls at the bottom.  I tried putting this

IIf(IsNull([CustomerPhone1]),"(999) 999-9999",[CustomerPhone1])

in my Criteria field but when I run the query it completely leaves out any
of the records with a blank phone number and just gives me the populated
ones.  What am I doing wrong?

Thanks.
Arica