Combinations in the where clause - Query

[sd110404]

Hi,

Let me just brief the pbm.

Lets take customer table with fields Customer ID, name, homePh, cellPh, workPh

I want to display only those customer name who have only one phone number or no phone number (it can be in any combinations, like the customer might have only cellPh or only homeph, or only workPh).

Is there any other way, other than mentioning the combinations in the where clause.

Thanks in advance.

 

[PHV]

SELECT * FROM tblCustomer
WHERE (IIf(Trim(homePh & "")="",0,1)+IIf(Trim(cellPh & "")="",0,1)+IIf(Trim(workPh & "")="",0,1))<=1

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[sd110404]

Thanks PHV