E Ennio Member Joined Mar 5, 2006 Messages 23 Programming Experience Beginner Mar 5, 2006 #1 I need to check to see if a field is NULL in the DB. I'm using MS Access as the DB. can I just do a select * from tbl_Test where Test = NULL
I need to check to see if a field is NULL in the DB. I'm using MS Access as the DB. can I just do a select * from tbl_Test where Test = NULL
P prav_roy Well-known member Joined Sep 10, 2005 Messages 70 Location Mumbai Programming Experience 1-3 Mar 5, 2006 #2 i do not know how to check for null values in Access, but in case of sql server you can make use of IS NULL Ie SELECT * FROM TABLE where COLUMN IS NULL Upvote 0 Downvote
i do not know how to check for null values in Access, but in case of sql server you can make use of IS NULL Ie SELECT * FROM TABLE where COLUMN IS NULL
