Answered
Recordset query
This must be an easy one, and I know I'll kick myself, but
its been a long day!
I'm basically just trying to filter out a table of contacts into two pages - one listing contacts that do have an email address, and one listing contacts that don't have an email address.
For the ones that do have an email address, I've used :
SELECT * FROM Candidates WHERE Email <> '' ORDER BY CandidateID DESC
Which works fine.
So I would have thought that :
SELECT * FROM Candidates WHERE Email = '' ORDER BY CandidateID DESC
would show all the candidates that didn't have an email address.
Can anyone put me out of my misery and remind what I do need to list contacts where the Email field is empty?
Thanks.
would show the ones that didn't have a email address.
I'm basically just trying to filter out a table of contacts into two pages - one listing contacts that do have an email address, and one listing contacts that don't have an email address.
For the ones that do have an email address, I've used :
SELECT * FROM Candidates WHERE Email <> '' ORDER BY CandidateID DESC
Which works fine.
So I would have thought that :
SELECT * FROM Candidates WHERE Email = '' ORDER BY CandidateID DESC
would show all the candidates that didn't have an email address.
Can anyone put me out of my misery and remind what I do need to list contacts where the Email field is empty?
Thanks.
would show the ones that didn't have a email address.
AdChoices