FUNCTIONS

  • Thread starter FamilyGuyFan1219
  • Start date
F

FamilyGuyFan1219

How do you Create and modify calculated fields and aggregate functions?
 
A

Arvin Meyer [MVP]

FamilyGuyFan1219 said:
How do you Create and modify calculated fields and aggregate functions?

Use a query. Add a column like:

Total: [Field 1] + [Field 2]

For aggregates, in a query, click on the Totals button (the Greek letter
Sigma) and choose the aggregate function from the box on the Total line.
 
Top