Recent content by Benep87

Hi John, Thanks for the reply. It sounds like I will still need to replicate your SQL code 130 times, one for each field, right?

Hi all, I have an access table with ~130 columns, all of which contain some null values. I need to replace all of these null values with zeros. I've seen lots of ways to replace null values within a single column, but repeating this action 130 times is pretty time consuming. Does anyone know...