query blank cells

[tbcwarrior]

hi all

i have created a database but didnt insert any default value at the begining and now i have blank cells in the table rather than £0.00

how would i go about querying the blank cells and then populating them with 0.00

thanks in advance

chris

 

[MStef]

Do it with UPDATE query.

 

[tbcwarrior]

thanks but how do i specify a blank entry ? as a blank cell is not equal to 0 is it

 

[MStef]

Blank = ""
Before take a copy of table.

 

[Jonathan Kok]

Is Null

No quotes, no "=". Just, plain, Is Null.

 

[MStef]

I think you have to use Is Null instead of "".

 

[MStef]

Ok, Jonathan is right.

 

[tbcwarrior]

thanks guys go it to work

i am quite new to access and will probably be asking many more questions

chris