Update Query - Expression to Delete Rows

  • Thread starter Thread starter orbojeff
  • Start date Start date
O

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
 
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.
 
Back
Top