Update Query - Expression to Delete Rows

[orbojeff]

I setup an Update Query and I would like to Build and Expression to
Delete a row if the Field Value is Null or "0"
What would the Expression look like?

Thanks
Jeff

 

[Allen Browne]

Jeff, this will be a different query--a Delete query instead of an Update
query.

This kind of thing:
DELETE FROM Table1 WHERE (Table1.Field1 Is Null) OR (Table1.Field1 = 0);

If Field1 is a Text type field (not a Number type field), put quotes around
the zero.

If your field of table names contain spaces or strange characters, put
square brackets around each name.

 

[Duane Hookom]

The where clause might look like:
WHERE Nz([the un-named field],0)=0