Restrict() method and Null values
I am trying to get a list of contacts (using the Restict() method) in a
Outlook 2003 Contact folder that do NOT have an Email1Address assigned.
These (Jet?) queries do NOT eliminate contacts without an Email1Address:
[Email1Address] ''
NOT([Email1Address] = '')
NOT([Email1Address] IS NULL) 'plus lower-case variations
"[Email1Address]" & Chr(34) & Chr(34)
Email1Address that are missing are considered Nothing in the Immediate
window, btw.
I'm using .Net framework 2.0. I am testing in Offline mode, if that makes a
difference.
Can someone shed some light on this for me?
Thanks,
Craig Buchanan
|