Updating a field in a table after an initial update

[kjpreston]

I have an Update query that updates tbl_Inven2004 with data from tbl_temp. Once this update is completed I need to change the Status field in tbl_Inven2004 to 'FOUND' if the field ScannerECN in tbl_Inven2004 is no longer null. I have tried, IIf([tbl_Inven2004]![ScannerECN] Is Not Null, [tbl_Inven2004]![Status]='Found', "")in as both criteria and as an expression but it doesn't work. Any ideas? I think I'm coming at this from the wrong angle but I can't seem to find the right one. Thanks

 

[PHV]

UPDATE tbl_Inven2004 SET Status='Found' WHERE ScannerECN Is Not Null;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[kjpreston]

Now to really show my ignorence. Where to I put it?

 

[PHV]

This the SQL code of an update query.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[kjpreston]

Thank you very much. You have been a tremendous help.