J
John
I have a data base which has several thousand blank cells in two of it's
fields. Not all the cells in those cells are blank though, only the first
few thousand. Those cells had no data available for much of the early part
of entering data. When I include these fields in a query on the table for
calculating certain totals across all the fields, I get serious errors in
the calculations. How can I populate these specific cells with zeros, or
otherwise remedy the problem to ensure accurate calculations for all the
cells including data.
I recall seeing a posting a while ago that might have shed some light on my
question, but I can't seem to find it now.
John
fields. Not all the cells in those cells are blank though, only the first
few thousand. Those cells had no data available for much of the early part
of entering data. When I include these fields in a query on the table for
calculating certain totals across all the fields, I get serious errors in
the calculations. How can I populate these specific cells with zeros, or
otherwise remedy the problem to ensure accurate calculations for all the
cells including data.
I recall seeing a posting a while ago that might have shed some light on my
question, but I can't seem to find it now.
John