Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
calculated field in new line sometimes gives an error
3 views
Skip to first unread message
Patrick
Jan 6, 2010, 2:01:01 AM1/6/10
to
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?
--
Patrick
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?
--
Patrick
Al Campagna
Jan 6, 2010, 2:23:38 AM1/6/10
to
Patrick,
Sounds like you have a null in there from time to time.
Try... (use your own object names)
= NZ(Field1,0) + NZ(Field,0) .... + NZ(Field5,0)
--
hth
Al Campagna
Microsoft Access MVP 2006-2009
http://home.comcast.net/~cccsolutions/index.html
Sounds like you have a null in there from time to time.
Try... (use your own object names)
= NZ(Field1,0) + NZ(Field,0) .... + NZ(Field5,0)
--
hth
Al Campagna
Microsoft Access MVP 2006-2009
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."
"Patrick" <Pat...@discussions.microsoft.com> wrote in message
news:8DBBC4AF-8A81-4777...@microsoft.com...
0 new messages