Populating multiple fields in a table with the same value

[AlexD]

Hi,

Hopefully an easy little problem for someone to help me with.

Have a table with multiple flag fields (initially populated with either Y, N or NULL).

Basically I want to know a way of updating all the Nulls in all the fields with an 'N' value in one go, without having to individually update all the NULLs in each field.

That's it...any help would be most appreciated.

cheers,

Alex

 

[Mile-O]

Use an Update Query using the Nz() function to convert all Nulls to False values.

 

[AlexD]

Thanks for your quick response Mile...seems to have done the trick