I have an Access database in which I need to update a "Payment" field. The problem stems from the fact that a blank in the Payment field results in faulty results on a report. I need to update the Payment field to zero (0.00) when the "Date Paid" field is "Null". I created the update query to update the "Payment" field to "0" with the criteria of "Is Null" in the "Date Paid" field ... however the results leave a blank instead of a zero.
I had neglected to put a default value in the form control when I created the database, so it is my fault. However, I've since fixed that part of it, but still have thousands of other records that need updating. Other than going through and filling in all of the "Payment" fields with zeros, is there a way to fix this?
Thanks a bunch for your help!
I had neglected to put a default value in the form control when I created the database, so it is my fault. However, I've since fixed that part of it, but still have thousands of other records that need updating. Other than going through and filling in all of the "Payment" fields with zeros, is there a way to fix this?
Thanks a bunch for your help!
