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

Lesson 22. Customizing a Query > Adding a Calculated Field

Adding a Calculated Field

Calculated fields are helpful when you need to compute a value in your database by performing a math function on one or more fields' contents. For example, you might want to calculate a 5 percent sales tax based on the price of each item you sell. Or, in our kennel example, you might want to calculate each dog's current age by subtracting its birth date from the current date.

To add a calculated field, such as a field that calculates sales tax, follow these steps:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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