Recent content by Jessica240

The Nz function worked perfectly! Thats what I needed all along but I didn't know about that until now. Thank you so much!

My goal is to have every blank record in my table to be updated to a zero. So in the design view of my update query, where it says "update to:" I put "0" and for the criteria I have "is null". I have attached 2 screen shots. I've been experimenting with it, trying different things to get the...

Hello All! I am trying to update several fields all at once in one single query. Also, I can only use the Design View (No SQL) The weirdest thing keeps happening though: The more fields I enter to get updated, the less rows get updated. For example, When I have only one field that gets...