Hello all. I just figured out that I have a problem somewhere in my SQL code. I have many queries that Create and Update tables in my database. I noticed that on a page that queries based on a specific column, that I get different results depending on whether I use IS NULL or = ''. To get around this, I am using something similar to the following:
sQry = "SELECT dbDocNo, dbReqRead, dbReadComp FROM tblCompleted WHERE dbKerberos = '" & vEmp & "' AND (dbQual IS NULL OR dbQual = '') AND dbReqRead <> '' AND dbCompleted = -1"
I am not sure what is causing this. Is it the way I am using the INSERT or UPDATE statements? Any help would be much appreciated.