Updating default numbers

[equaliser]

I'm not sure which forum to ask this in so I've popped it in here.

I've just had to alter a couple of reports to add some calculations. These calculations can only work with a figure in certain fields, so i've altered the default setting of the fields to '0'.

Now my problem!!!!!!! This is fine for any new records generated. How do I place a '0' in the 2000 odd records already generated without manualy inputting them in???

cheers

EQ

 

[Dwight]

You can slip in a 0 for in place of any nulls by using the NZ function. NZ(Field,0).

Lots of examples here if you need help.

 

[neileg]

Or use an update query.