I coded this version of a DELETE statement:
instead of this query in the DB:VB Code:
strSQL = "DELETE Main.Month FROM Main WHERE Main.Month <> '" & mstrMonth & "';" 'DoCmd.RunSQL (strSQL)
Is the coded SQL correct? I'm suspicious of it, even though it returns the same results.VB Code:
DELETE Main.Month FROM Main WHERE (((Main.Month)<>[Which month are you working on?]));




Reply With Quote