Text "Access"

[PeachDuster]

I have been stumped on this for a little while and would greatly appriciate
it if someone could help me. I need to sort a text parameter that is a
telephone number but show only the customers who don't have telephone
numbers. I have literly spent a few hours + more trying to figure this out,
if you have an answer or can point me in the right direction it would be
greatly appriciated. Thank you

 

[Clif McIrvin]

I have been stumped on this for a little while and would greatly
appriciate
it if someone could help me. I need to sort a text parameter that is a
telephone number but show only the customers who don't have telephone
numbers. I have literly spent a few hours + more trying to figure this
out,
if you have an answer or can point me in the right direction it would
be
greatly appriciated. Thank you

I think we need more information:

Are you writing a Query? Using the Query design Grid?

What version of Access?

I'm not sure how "sort" and "don't have" go in the same sentence
together.

Try filtering on "Is Null" and see what that does for you.

 

[Tom Wickerath]

Hi Clif,

In addition to setting a criteria for Is Null, one may need to include a
criteria for zero lenght strings (ZLS), if these are allowed for the field in
question (ie. "Allow Zero Length" = Yes, in table design view, for the field
in question). You can capture both cases with this criteria:

Criteria: Is Null Or =""

See Access MVP Allen Browne's write up on ZLS:

Problem properties ---> See Fields: Allow Zero Length
http://allenbrowne.com/bug-09.html


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Clif McIrvin]

Thanks, Tom. that looks to be worth remembering!

I still wonder what OP was trying to do.....

Oh well; I don't plan on losing any sleep over it!

--
Clif

Hi Clif,

In addition to setting a criteria for Is Null, one may need to include
a
criteria for zero lenght strings (ZLS), if these are allowed for the
field in
question (ie. "Allow Zero Length" = Yes, in table design view, for the
field
in question). You can capture both cases with this criteria:

Criteria: Is Null Or =""

See Access MVP Allen Browne's write up on ZLS:

Problem properties ---> See Fields: Allow Zero Length
http://allenbrowne.com/bug-09.html

<snip>

 

[Tom Wickerath]

Hi Clif,

I still wonder what OP was trying to do.....

My guess is that the OP needs a list of customers, sorted ascending, for
which they have no phone number. That way, they can use this list to look up
their missing data, and get it entered into their database.


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________