Make field Required

[Dan @BCBS]

I need to make a field manditory. It has 50K records and of those 35K are
blank. It's a text field and the user enters yes or no.
How can I give the 35K a value of "no" then I can make the field required?

Thanks

 

[Dan @BCBS]

You say "Just run find and replace"!
Is this a type of query? Could you please expalin a little lower level.

Thanks

 

[Dan @BCBS]

Perfect
Thank you very much.

Hi Dan,

You could do it with a query but easier would be:

open the table, click on the name of the field you want to update and the
column will be selected (highlighted), click control-F and the Find pop-up
will appear. Now select the second tab on the pope-up (Replace). In the top
option (Find What put "NULL" (without the quotes), in the second option
(Replace With put exactly what you want in the empty field (NO without
quotes). Click Replace All. Voila!

Make sure you make a copy of your table first to be safe.

Bonnie
http://www.dataplus-svc.com

You say "Just run find and replace"!
Is this a type of query? Could you please expalin a little lower level.

Thanks

Hi Dan,

[quoted text clipped - 11 lines]

Thanks