Q
QuadSquad
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
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