How can I find and replace null values in Access? 2

[Joeclueless]

I have collumns that have null values. I want to be able to replace these blank cells with a standard string of text.
How might I do this? Thanks again!

Joe

 

[mdthornton]

To give your blank fields a value write an update query like this:

UPDATE MyTable SET MyTable.MyField = "xyz"
WHERE MyTable.MyField Is Null;

If you want to avoid blanks in the future try setting a default value for the field(s) in the table design view. Good Luck,
Mike

 

[Joeclueless]

Thanks Mike!

Appreciate the info! Thanks again!

Joe

 

[binain]

The other option, if you want to keep the values as Null in your tables, is to output them as

Nz(Fieldname,"Value instead of Null&quot

For example
Nz([Gaskets Sold],0)
Nz([Age],"no age given&quot

 

[Joeclueless]

I'm trying the update query and I'm getting the error of "Not enough memory or disk space to complete...yada yada..."

I'm not sure why? I have plenty of disc space (over 1.5 GB) and 256 Mhz of ram??

Any Ideas?? Thanks again!

Joe

 

[Joeclueless]

BINAIN Thanks again!

Joe