Hi,

I'm using Access 2000 and .asp. In my database a field called "complete" has 3 possible values, "Yes" "Reported" and the other (the default) is empty.

I cannot get my sql to work properly. If I use "<> Yes" I only get the entries with "Reported" in them.

What I want to be returned is everything that is still empty. Any ideas....THANKS!!!

Is it empty or is it null? (They are 2 different things).

If it is an empty string you could do:

SELECT ... WHERE complete in('Reported', '')

or if it is null

SELECT ... WHERE complete = 'Reported' and complete is null

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

The field actually by default is empty.

I need only the records that are still empty to pull for my search query, not the ones with "Yes" or "Reported".

I can't get Access to accept just a blank in the SQL statement, do I need to surround it by quotes or parantheses?

THANKS soooo much!

Might be a long shot (I havent used access for over a decade) but you can try this:

SELECT .... WHERE Complete not in ('Reported','Yes')

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

If by "empty" you mean Null, then you could use: I am a loud man with a very large hat. This means I am in charge