Inserting SUM

  • Thread starter Thread starter Shell
  • Start date Start date
S

Shell

I have a form that collects some data and som are values. I would like to
place a total for the values i.e., dollar entries are made in 6 fields and I
would like to SUM the value of the 6 entries i.e. $1.00 in filed one, $2.50
in field 2, and so on and sub-total it.

For the life of me, I can't find where to get some SUM formulas to insert.

Also, can you suggest a web where people offer their ACCESS services -
perhaps I should pay someone to develop whet I need. :)
 
First, the Sum doesn't work in VBA code, it would be used in SQL code, and
some expresions in form and report controls. There is a DSum function, but
it would sum the field across multiple records. If you have multiple fields
in one record and you want to show the total of those fields, you would use a
text box control on your form and add them together using the text box
control's Control Source property. For example:
=[FieldOne] + [FieldTwo] + [FieldThree]

If you need professional help, post back with your e-mail address and I will
contact you.
 
Thanks - let's start email with Hotmail and I'll pass my real email on
through there. contact me as (e-mail address removed)

Look foward to hearing from you.

S

Klatuu said:
First, the Sum doesn't work in VBA code, it would be used in SQL code, and
some expresions in form and report controls. There is a DSum function, but
it would sum the field across multiple records. If you have multiple fields
in one record and you want to show the total of those fields, you would use a
text box control on your form and add them together using the text box
control's Control Source property. For example:
=[FieldOne] + [FieldTwo] + [FieldThree]

If you need professional help, post back with your e-mail address and I will
contact you.
--
Dave Hargis, Microsoft Access MVP


Shell said:
I have a form that collects some data and som are values. I would like to
place a total for the values i.e., dollar entries are made in 6 fields and I
would like to SUM the value of the 6 entries i.e. $1.00 in filed one, $2.50
in field 2, and so on and sub-total it.

For the life of me, I can't find where to get some SUM formulas to insert.

Also, can you suggest a web where people offer their ACCESS services -
perhaps I should pay someone to develop whet I need. :)
Click to expand...
Click to expand...
 
Back
Top