Replacing Table values

G

Guest

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.
 
D

Douglas J Steele

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Appending results of loop to a table 2
Table comparison 6
Utilizing Recordset field in vb Requery Command Verbiage 1
Replace text using recordset 3
Access Command button to look up and copy data from a query to a table 0
Loop thru all fields in all tables to replace bogus data 7
Update certain record fields in one table if data exists in anothe 1
How to find a value in a table? 5

Top