Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Loop Through Columns and set Nulls to 0 (zero)
Thanks for the tips guys. And yes, I know I need to normalize this table at some point, this is just a database I inherited so until I have more time to spare I am working with what I have.- mavrrick
- Post #6
- Forum: Microsoft: Access Modules (VBA Coding)
-
Loop Through Columns and set Nulls to 0 (zero)
Hello, I am running a MS Access query manually where I select each individual data field and set it to zero (0) if the criteria is Null. There are over 25 fields (and increasing), so I was attempting to find a simplier way to automate this process (e.g. a For Next loop). Doing it once looks...- mavrrick
- Thread
- Replies: 5
- Forum: Microsoft: Access Modules (VBA Coding)
