Columnar reports generally display one or more records per page, but do so vertically. Columnar reports display data very much as a data-entry form does but are used strictly for viewing data and not for entering data. Figure 37-2 shows part of a columnar report (rptProducts) in Print Preview.

Another type of columnar report displays one main record per page (like a business form) but can show many records within embedded subforms. An invoice is a typical example. This type of report can have sections that display only one record and at the same time have sections that display multiple records from the many side of a one-to-many relationship—and even include totals.

Figure 37-3 shows an invoice report (rptInvoice) from the Access Auto Auctions database system in Report view.

FIGURE 37-2
A columnar report showing report controls distributed throughout the entire page.

FIGURE 37-3
An invoice report (rptInvoice).

In Figure 37-3, the information in the top portion of the report is on the “main” part of the report, whereas the product details near the bottom of the figure are contained in a subreport embedded within the main report.

• Spreadsheets Considered Harmful AbstractDecentralized archetypes and write-ahead logging have garnered great interest from both electrical engineers and steganographers in the last several years...
• Another Listing Cancelled by Prosper.com Pre-Funding. Thank you!!! Another listing on which I was a winning bidder was cancelled during the pre-funding verification.  While, I am trying to...
• Mobile Ad Spend Projections Coda Research has released a report that says that mobile ad spends will rise to a whopping $4.2 billion by...
• Save Time, Money and Space in Over 80 Ways If you're looking for handy gadgets, tools and various items that can save you time, money or space (or all...
• Mortgage Home Possessions Continue to Rise The last two quarters of 2008 have seen a steady increase in the number of mortgage possession orders reaching the...