P
Patrick
Strange...
I have a form in datasheet view with 5 numerik fields. I added an extra
calculated field to sum the 5 numerik fields.
This all goes ok.
The 5 fields have a default value of 0, so the "new line" row contains 5
zero's with are summed as 0.
When entering a new line, the "new" new line that instantly appears gives an
error on the calculated field (#Error). This does NOT always happen.
Sometimes it does, sometimes it calculates 0
????????
What might be causing this?
I have a form in datasheet view with 5 numerik fields. I added an extra
calculated field to sum the 5 numerik fields.
This all goes ok.
The 5 fields have a default value of 0, so the "new line" row contains 5
zero's with are summed as 0.
When entering a new line, the "new" new line that instantly appears gives an
error on the calculated field (#Error). This does NOT always happen.
Sometimes it does, sometimes it calculates 0
????????
What might be causing this?