Replacing Table values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jauner - 07 Dec 2005 19:55 GMT

Is there a fairly easy way to loop through the table collections and if a
table has a number field to loop through each row and replace with zero if
null?

It can be multiple fields in the table.

Reply to this Message

Douglas J Steele - 07 Dec 2005 20:04 GMT

Why? Null has specific meaning: replacing Nulls with 0 could screw things up
if your users realize what Null means.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Is there a fairly easy way to loop through the table collections and if a
> table has a number field to loop through each row and replace with zero if
> null?
>
> It can be multiple fields in the table.

Reply to this Message