Delete with WHERE Clause. 2

[serino]

Need some help here. Why is this not working?

DELETE FROM HR_021_Isolates_Records_For_Anniversary_Reset_Table WHERE HR_021_Isolates_Records_For_Anniversary_Reset_Table.Code="Unpaid" AND HR_021_Isolates_Records_For_Anniversary_Reset_Table.UTimeTaken=Null AND HR_021_Isolates_Records_For_Anniversary_Reset_Table.OFTimeTaken=Null;

 

[Axworthy]

Jet SQL requires DELETE * FROM instead of DELETE FROM that works for most other versions of SQL.

 

[dhookom]

In addition to Axworthy’s reply, you shouldn’t use "=Null". Always use "is Null".

HR_021_Isolates_Records_For_Anniversary_Reset_Table.UTimeTaken is Null AND
HR_021_Isolates_Records_For_Anniversary_Reset_Table.OFTimeTaken is Null;

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[Andrzejek]

To see the record(s) you want to Delete, it is beneficial to Select them first just to make sure you will delete record(s) you want:
If you do:
[tt][blue]
SELECT[/blue] * FROM HR_021_Isolates_Records_For_Anniversary_Reset_Table
WHERE Code = "Unpaid"
AND UTimeTaken Is Null
AND OFTimeTaken Is Null;
[/tt]
and if that looks OK, then just change [blue]Select[/blue] to [red]Delete[/red]

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[serino]

Thanks you both. I must of copied and pasted the code incorrectly I did have DELETE * in there but fixing the null did the trick.