delete null records

stealthdevil · January 22nd, 2007, 01:35 PM

Hi,
I'm trying to use this line of code to delete all the null records in a table. Current is the only field in the table. It runs without an error, but it doesn't appear to do anything. What's wrong with this?

Code:

DoCmd.RunSQL (" DELETE * FROM tbl_current_reserve WHERE tbl_current_reserve.[CURRENT] = NULL ")

Thanks,
Dave

stealthdevil · January 22nd, 2007, 04:59 PM

Nevermind,

"is Null" instead of "= Null"

mmcdonal · January 23rd, 2007, 08:31 AM

The reason is that nothing = Null, not even Null. So it can never be used for a condition, as you have found out.

mmcdonal

stealthdevil · January 23rd, 2007, 04:48 PM

Quick question. just because I'm curious and don't know.
Why does this code work for setting something equal to Null?

Code:

iMid = Mid(sField, 7, 2)
    If iMid >= iSkip Then
        rsCur.Edit
        rsCur![Current] = Null
        rsCur.Update
    End If