Delete Field Value in a Tbl

[Mac1206]

I have a Table (A) which I need to delete a field value based off another filed in that table..Delete Field_Value = YES WHERE Field_Maryland = Toys Example:

Field_Maryland Field_Value
Toys Yes

So if my Field_Maryland = TOYS, DELETE Field_Value = YES...Thanks in Advance

 

[Mac1206]

Thanks Joe and xenou, can I write an update as such; UPDATE MyTable SET [C] = -([A]+[D]+[E])

 

[Joe4]

Thanks Joe and xenou, can I write an update as such; UPDATE MyTable SET [C] = -([A]+[D]+[E])

Yes. You should just be able to substitute in your field names for the letters.

 

[Mac1206]

Yes. You should just be able to substitute in your field names for the letters.

I'm noticing if I have a Null or Blank then those particular rows bring back a blank regardless if the others have actual values present, why is this???

 

[Joe4]

You cannot use null values in mathematical expressions.
You can use NZ to convert any null to zero, i.e. for any field which may have null values, substitute this:

Nz([FieldName],0)

See https://www.techonthenet.com/access/functions/advanced/nz.php

 

[Mac1206]

You cannot use null values in mathematical expressions.
You can use NZ to convert any null to zero, i.e. for any field which may have null values, substitute this:

Nz([FieldName],0)

See https://www.techonthenet.com/access/functions/advanced/nz.php

Joe, how would I include this in my update query ; UPDATE MyTable SET [C] = -([A]+[D]+[E])

 

[Joe4]

Just like I said.
If you need help, please post your actual query with actual field names, and let us know which fields may have Nulls in them.

 

[Mac1206]

Just like I said.
If you need help, please post your actual query with actual field names, and let us know which fields may have Nulls in them.

Thanks Joe, I got it up and running correctly now utilizing Ms Access Nz([Field],0)...You guys are the greatest...Hoorah