Help with code Syntax

[jtm013]

Hello,

I am trying to purge some redundant data from my database by using the following code:

DoCmd.RunSQL "Delete * From [tblDataPrime] WHERE [ToolLastCalDate] = ''"

I know this syntax works if I put a word inbetween the single quotes after the equals sign.


However, I need it to target cells which are empty and I have not been able to figure out how to structure that.

Any and all assistance is appreciated.

[JoeM]

If it is truly a date field, you probably do not have an empty string, but rather a Null. Try:

DoCmd.RunSQL "Delete * From [tblDataPrime] WHERE [ToolLastCalDate] Is Null"

[jtm013]

If it is truly a date field, you probably do not have an empty string, but rather a Null. Try:

DoCmd.RunSQL "Delete * From [tblDataPrime] WHERE [ToolLastCalDate] Is Null"

That did the trick thanks!!!