Create Queries with Calculated Fields and Aggregate Functions

Create a new field in an Access database query that is a formula/calculation based off of an existing field. Use aggregate functions like average and sum to display summary data about query results.

• #howto_style
• #access
• #database
• #query
• #queries
• #design
• #calculated
• #field
• #aggregate
• #average
• #sum
• #total