Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

summing data from multiple entries

Status
Not open for further replies.

slaga9

Technical User
Jun 8, 2007
46
CA
On a form I have 3 fields which I sum to get (total 1) for each entry.

For each entry, I wish to be able to add the previous entries (total 1) to their own (total 1), to get (final total).

does this make sence and is this possible? If so, what is the best way to go about doing it?
Thank you
Sean
 
Generally I say use forms for data entry and reports for reporting.

But you should be able to put a text box that sums in either the form header of footer.

Control source should be...

Code:
=Sum(Field)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top