F FamilyGuyFan1219 May 6, 2008 #1 How do you Create and modify calculated fields and aggregate functions?
A Arvin Meyer [MVP] May 6, 2008 #3 FamilyGuyFan1219 said: How do you Create and modify calculated fields and aggregate functions? Click to expand... 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.
FamilyGuyFan1219 said: How do you Create and modify calculated fields and aggregate functions? Click to expand... 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.
