blank values need 0's

[teiben]

I need to quickly replace "blank values" with 0's, as a result of users skipping over questions; I've tried doing a find and replace but that didn't work, it seems like I've run into this problem before but my brain has locked up

 

[marleymanner1]

if you're talking about users skipping over questions in a form, and eventually getting the data to a table, then it's using the NULL. you can put 0's in the form controls upon saving the record, or exiting the form...whichever comes first. if you want to replace these things in the table itself, I recommend opening the table in datasheet view, pushing Ctrl+F on your keypad, and typing in NULL where it says "find", and then "0" where it says "replace". then hit REPLACE ALL.

 

[gemma-the-husky]

you can certainly do an update query that sets values to 0,1 whatever where the criteria is null

in sql

UPDATE Table1 SET Table1.myfield = "1"
WHERE (((Table1.myfieldl) Is Null));

the bracketing is over complex, but that is what access actually generated!

 

[Ron_dK]

In addition to what Gemma said, make sure the field property "Defualt value" is set to 0

Hth

 

[WayPay]

In addition to what Ron_dK said, make sure the field property "Required" is set to Yes.

Htht