Access Query Question

SELECT *
FROM phone
WHERE (((Len([cell]))<10));

This is for finding a cell phone number that is less than 10 digits. How can I make it so it will find any phone number less than 10 digits that is either [cell] or [home]
LVL 3
Computer GuyAsked:
Who is Participating?
 
dsackerContract ERP Admin/ConsultantCommented:
SELECT *
FROM phone
WHERE Len([cell]) < 10 OR Len([home]) < 10;
0
 
Dale FyeCommented:
Well, I would generally store phone numbers in a separate table, so I don't have to have separate columns for the Type of phone.  That table might look like:

PersonID    PhoneType   Phone_Number

or possibly:

PersonID   PhoneTypeID  PhoneNumber

In the first example, PhoneType would be a text field, but I prefer to have a tbl_PhoneTypes with PhoneTypeID and PhoneType, to allow the user to select from a list of phone types, rather than entering the text.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.