Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

MS Access

Posted Oct 6, 2003

MS Access for the Business Environment: Reporting in MS Access: Grouped Transactional Report Part II - Page 7

By William Pearson

21.  Using the methods we have outlined previously, move the OrderDate compound control so that its left border is aligned with the 1/4-inch point on the horizontal ruler.

This should align the OrderDate compound control in the footer with the compound control from which it was cloned in the OrderDate header. We want to make one alteration, however; a modification to the existing text in the label control to make it more meaningful in its context within the footer.

22.  Right-click the OrderDate label control in the OrderDate footer.

23.  Select Properties from the context menu that appears.

24.  Select the Format tab of the Properties sheet, as necessary.

25.  Modify the Caption field at the top of the Format tab to read as follows:

Totals for:

The Properties sheet - Format tab for the OrderDate label control appears as depicted in Illustration 24.

Illustration 24: Properties sheet - Format tab for the OrderDate Label Control

26.  Close the Properties sheet.

27.  Move the pointer to the bottom of the OrderDate footer section, placing it between the OrderDate footer section and the CustomerID footer section.

28.  Hold down the left button on the mouse, as soon as the "double-arrow" image appears.

29.  Drag the CustomerID footer section border up, until a tight fit is achieved for the controls we have included.

30.  Release the button to fix the border in place.

The OrderDate header and footer sections now appear in the report as shown in Illustration 25.

Illustration 25: OrderDate Header and Footer Sections (Partial View) with Our Adjustments

Let's perform another preview of our evolving report.

31.  Click the Print Preview button.

32.  Type the following into the AsOfDate box that appears:


33.  Click OK to apply the date.

The report executes, returning data that appears similar to that partially shown in Illustration 26.

Illustration 26: The Report Preview - Partial Sections

Let's take a look at the overall page layout from a somewhat "higher" level; while it might make the specific data harder to see, the zoom option for Preview is certainly useful in getting a feel for the overall page layout.

34.  Pass the mouse cursor over the report until a magnifying glass icon (with a " - " sign inside it) appears.

35.  Click the report once.

The report appears in reduced magnification mode, actually "zooming out," affording us a general "page" view of overall layout of the report, as shown in Illustration 27.

Illustration 27: The Report Preview - Zoomed Layout View

Again, we see that the report is developing according to our objectives.

36.  Click the Close button to close the Preview window.

37.  Save your work as desired, as a safety measure.

Next, we will move into the CustomerID header and footer sections.

MS Access Archives

Latest Forum Threads
MS Access Forum
Topic By Replies Updated
Help With Microsoft Access kasy 0 September 4th, 07:35 PM
Linked table not sorting or filtering - ODBC error Java 1 August 28th, 10:37 AM
Use Parameter in select statement (Sql in Microsoft Access) katty.jonh 1 July 25th, 06:45 AM
Query Issue algebroni 7 July 23rd, 04:22 PM