Skip to Main Content

Archive for January, 2010

Grouping Data in Access Reports

By applying a few simple techniques, you can make your Access  reports look more professional and more informative than ever before!

Adding Alphabetic Headings

In large reports, it is often useful to emphasize alphabetical groupings by adding text boxes that contain the first character for each group:

Adding Alphabetic Headings





Read the rest of “Grouping Data in Access Reports” »

Displaying Aggregate Expressions on a Main Form from a Subform

In Microsoft Access, when a main form and subform are created based on one-to-many relationships, you can display aggregate information in the main form; for example, a total COUNT of customer records for each sales person or a SUM total of sales amounts that have been displayed in a subform.

As you scroll through this main form, many customers may be associated with each sales representative:

Aggregate Count

Read the rest of “Displaying Aggregate Expressions on a Main Form from a Subform” »

Get Training Tips via RSS Subscribe to Entries feed or Read Comments via RSS Subscribe to Comments feed.