How do I add data from three different fields in an Access form?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to add (sum) three fields on a form into another field using
=Sum(""[Content GPA],[Student Teaching Assessment],[Praxis II]"")
But I keep getting errors. I've moved many operations around and I can't get
the total right.

By the way, is it a problem that all of these fields are in the same table?
 
In a new unbound field in your form simply put the following:

=[Content GPA]+[Student Teaching Assessment]+[Praxis II]
 
Suntayea said:
I am trying to add (sum) three fields on a form into another field using
=Sum(""[Content GPA],[Student Teaching Assessment],[Praxis II]"")
But I keep getting errors. I've moved many operations around and I can't
get
the total right.

By the way, is it a problem that all of these fields are in the same
table?
Click to expand...

What errors are you getting? Are these fields contained in the table to
which the form is bound?

Carl Rapson
 
Use the Control names, not the field names. Also, for new record, it would
be best to include the Nz function for each control so the value will
increment as the controls are filled in. Otherwise, you will not see a value
until all 3 controls have values because Null + anything = Null.

=Nz(txtContentGPA,0)+Nz*txtStudentTeachingAssessment,0)+Nz(txtPraxisII,0)


--
Dave Hargis, Microsoft Access MVP


RBear3 said:
In a new unbound field in your form simply put the following:

=[Content GPA]+[Student Teaching Assessment]+[Praxis II]


--
Hope that helps!

RBear3
..

Suntayea said:
I am trying to add (sum) three fields on a form into another field using
=Sum(""[Content GPA],[Student Teaching Assessment],[Praxis II]"")
But I keep getting errors. I've moved many operations around and I can't
get
the total right.

By the way, is it a problem that all of these fields are in the same
table?
Click to expand...
Click to expand...
 
Thank you so much, after letting go of the thought all weekend. I finally
figured it out. :)

RBear3 said:
In a new unbound field in your form simply put the following:

=[Content GPA]+[Student Teaching Assessment]+[Praxis II]


--
Hope that helps!

RBear3
..

Suntayea said:
I am trying to add (sum) three fields on a form into another field using
=Sum(""[Content GPA],[Student Teaching Assessment],[Praxis II]"")
But I keep getting errors. I've moved many operations around and I can't
get
the total right.

By the way, is it a problem that all of these fields are in the same
table?
Click to expand...
Click to expand...
 
Thanks bunches!!

Klatuu said:
Use the Control names, not the field names. Also, for new record, it would
be best to include the Nz function for each control so the value will
increment as the controls are filled in. Otherwise, you will not see a value
until all 3 controls have values because Null + anything = Null.

=Nz(txtContentGPA,0)+Nz*txtStudentTeachingAssessment,0)+Nz(txtPraxisII,0)


--
Dave Hargis, Microsoft Access MVP


RBear3 said:
In a new unbound field in your form simply put the following:

=[Content GPA]+[Student Teaching Assessment]+[Praxis II]


--
Hope that helps!

RBear3
..

Suntayea said:
I am trying to add (sum) three fields on a form into another field using
=Sum(""[Content GPA],[Student Teaching Assessment],[Praxis II]"")
But I keep getting errors. I've moved many operations around and I can't
get
the total right.

By the way, is it a problem that all of these fields are in the same
table?
Click to expand...
Click to expand...
Click to expand...
 
Thank you, I figured out the problems. I don't remember the errors now.

Carl Rapson said:
Suntayea said:
I am trying to add (sum) three fields on a form into another field using
=Sum(""[Content GPA],[Student Teaching Assessment],[Praxis II]"")
But I keep getting errors. I've moved many operations around and I can't
get
the total right.

By the way, is it a problem that all of these fields are in the same
table?
Click to expand...

What errors are you getting? Are these fields contained in the table to
which the form is bound?

Carl Rapson
Click to expand...
 
HI

what if I want to have a field that sums others but I want the data form it
to be kept in the table as well (unbound field will only return the value -
wont save it anywhere...)???

Thanks
--
Gosha


RBear3 said:
In a new unbound field in your form simply put the following:

=[Content GPA]+[Student Teaching Assessment]+[Praxis II]


--
Hope that helps!

RBear3
..

Suntayea said:
I am trying to add (sum) three fields on a form into another field using
=Sum(""[Content GPA],[Student Teaching Assessment],[Praxis II]"")
But I keep getting errors. I've moved many operations around and I can't
get
the total right.

By the way, is it a problem that all of these fields are in the same
table?
Click to expand...
Click to expand...
 
Back
Top