If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Text "Access"
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 |
#2
|
|||
|
|||
Text "Access"
"PeachDuster" wrote in message
... 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. -- Clif Still learning Access 2003 |
#3
|
|||
|
|||
Text "Access"
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/ex...tributors.html __________________________________________ "Clif McIrvin" wrote: 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. -- Clif Still learning Access 2003 |
#4
|
|||
|
|||
Text "Access"
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 "Tom Wickerath" AOS168b AT comcast DOT net wrote in message ... 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 |
#5
|
|||
|
|||
Text "Access"
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/ex...tributors.html __________________________________________ "Clif McIrvin" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|