M
Martin Ibbotson
I wish to create a view filter that will only display those contacts
that have either a mobile phone no, a business phone no, or a home phone
no.
I've been into View|Arrange By|Current View|Define Views
I've selected "Phone List" and then Modify|Filter|Advanced
Now the question is - How do I create an "or" condition with the fileds
in which I'm interested?
I've realised that if you select a field, a condition and a value for
more than one field, then they act in an "and" conditional relationship,
which means that you only get contacts that have values in all the
fileds.
(I'm not an SQL expert otherwise I might have tried that)
Can anyone offer any help on this one? I can't find any appropriate
topic in the Help system.
Many thanks,
Martin
that have either a mobile phone no, a business phone no, or a home phone
no.
I've been into View|Arrange By|Current View|Define Views
I've selected "Phone List" and then Modify|Filter|Advanced
Now the question is - How do I create an "or" condition with the fileds
in which I'm interested?
I've realised that if you select a field, a condition and a value for
more than one field, then they act in an "and" conditional relationship,
which means that you only get contacts that have values in all the
fileds.
(I'm not an SQL expert otherwise I might have tried that)
Can anyone offer any help on this one? I can't find any appropriate
topic in the Help system.
Many thanks,
Martin