Sum data in one field throughout a database

[alexf]

Is it possible to sum the data stored in a field of the total records in a Database and display the value of that sum?

Thank you.

[Kurt Knippel]

quote:

---

Originally posted by alexf:

Is it possible to sum the data stored in a field of the total records in a Database and display the value of that sum?

Thank you.

---

The Sum(FieldName) works on whatever the found set is.

The GetSummary (FieldName, BreakField) can be used by having a breakfield which include ALL records in the DB, such as a global or a constant.

One or both of these methods should give you the results you are looking for.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Consultant

Database Resources

mailto:[email protected]

http://www.database-resources.com

=-=-=-=-=-=-=-=-=-=-=-=-=