• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 28. Beyond the Basics > Performing Calculations by Using Queries

Performing Calculations by Using Queries

Access makes it possible to perform all sorts of calculations in a query. You can count the number of records that match a query, sum the value of a particular field, calculate averages, and much more. You can also create your own formulas to calculate values based on the data in a table.

For example, perhaps you want to create a query that calculates the total annual salary for each employee. The query needs to multiply the Payrate field by 12 to come up with an annual value.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint