Delete records with criteria

[ckleung]

Hi,

I have written the following code:

CurrentDb().Execute "Delete * From BasicData Where IsNull([DischargeDate] = False)"

However, the outcome is that all the records that [DischargeDate] without data were deleted. I want to delete the records that [DischargeDate] had fill in data.

Can anyone help? Thanks in advance.

 

[Rich]

Try, Not IsNull instead

 

[ckleung]

Thanks Rich and Pat

Thanks a lot. You let me get more understanding in writing codes.
Actually, I tried the way Rich showed me, and I also try the following code:

where IsNull([DischargeDate]) = False

It also works.