Adding data from records

[Victor]

Does someone know how to simply take all the records in a
field, add the numbers together, and then update the sum
in to a record at the bottom of the field? I need this
to happen each time a new record is added to the field,
automatically. Thanks for any help!

 

[Steve Schapel]

Victor,

Well, not really the way you describe it. But in the form footer of
your data form, you can just put an unbound textbox, with its Control
Source set to the equivalent of...
=Sum([NameOfYourField])
Will that serve the purpose?

 

[Guest]

yes I did get that to work in a report but I need it to
add the summed value back to a field or record in the db
so I can use it in a program.

 

[Steve Schapel]

Victor

I gues you would be able to use an Append Query or an Update Query to
put this value into a table. But in reality, this would be a very
unusual thing to do. It is probably simpler to just export to the
external program directly from a Totals Query. Maybe if you could give
a bit more information about what you are trying to achieve, maybe with
examples, it would make it easier for someone to give more precise help.