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

Chapter 8. Queries > Adding Calculated Fields

Adding Calculated Fields

Queries give you the freedom to both retrieve records and manipulate them. Notably, you can add fields that display the results of a calculation on stored values.

Using an Arithmetic Expression

For example, suppose you were anticipating that purchase prices would rise uniformly for all products about 8%. You want to create a field that will show what the new prices will be for each product.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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