I'm trying to only display records where the field SHARE_INFO is = No. I'm almost positive my code is correct, but I can't get it to work. Is it possible that the field in the database is corrupted? If so, is there a way to fix that?
My select statement is:
Set RS = DB.Execute("SELECT * FROM registrants WHERE share_info <> 'No' ORDER BY last_name ASC")
I've changed it to check a value in another field and it works fine. But no matter what I do with the SHARE_INFO field I get no records returned.
good point jimmykav, I forgot to point that one out. NULL is not a value, it's no value (a state), therefore cannot be compared to anything.
@kevinj: I'd use the whole statement as I posted it. Depending on the DBMS and the front end (where a user can change a 'No' to an empty value or an emtpy string), the value could end up being '' and not NULL.