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

Chapter 15. Constructing a Report > Starting from Scratch—A Simple Report

Starting from Scratch—A Simple Report

In a contact tracking application, the user is going to want to take a look at recent events and perhaps work through a list of events that require follow-ups. Although the user could search for events in a form, the application should also provide a report that lists events by contact and shows the phone numbers the user needs. This report can be filtered by the application to print out only recent and upcoming events.

Most reports gather information from several tables, so you’ll usually design a query that brings together data from related tables as the basis for the report. In this section, you’ll build a relatively simple report to list contact events as you tour the report design facilities. The report you’ll build uses the tblContacts, tblContactEvents, and tlkpContactEventTypes tables in the ContactsDataCopy.mdb sample database. The report groups contact event data by contact, prints a single line for each contact event, and calculates the number of contact events and the number of follow-ups for each contact.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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