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

Chapter 4. Taming Access Data > Adding Calculations to a Report

Adding Calculations to a Report

Reports are often used just to display data. For example, it might be enough that an inventory report displays the in-stock, reorder level and on-order values for all a company’s products. But anyone who uses a report as part of a decision-making process probably wants more than mere data. Such a person likely also needs to analyze the data in some way, and most data analysis requires one or more calculations. What were the total sales last quarter? How many days overdue are the unpaid invoices? How many records are in this report?

To answer these and many other questions within a report, you need to add one or more calculations. In the report Design view, you add calculations by adding text boxes, which you can use as unbound controls that display calculated results.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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