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

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
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 8

By William Pearson

Working with the Customer Header and Footer Sections

The next header and footer sections with which we will deal in the Customer Orders Report will act to group order information by customer. The Customer header and footers will enclose the OrderDate group, within which lies the Detail information. The steps involved in setting up this part of our report will be quite similar to those of the OrderDate sections that we assembled above, once again occurring within the Design View for the report.

1.  In the Field List, click the CustomerID field.

2.  Hold down the SHIFT key, to allow the simultaneous selection of contiguous fields.

3.  Click the CompanyName field.

4.  Drag the fields together to the CustomerID section.

5.  Drop the fields / controls at a point in the upper left hand corner of the CustomerID header.

6.  Align the compound control approximately with the 1/8-inch tick on the horizontal ruler, as flush to the top of the CustomerID section as possible.

7.  Right-click the CustomerID label control.

The Properties page for the CustomerID label control appears, with the Format tab as the default view.

8.  Modify the Caption to read as follows:

Customer:

9.  Change Font Weight to Bold.

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


Illustration 28: Properties sheet - Format tab for the CustomerID Label Control

10.  Close the Properties sheet.

The Properties sheet disappears.

11.  Click the CustomerID text control to select it alone.

12.  Pass the cursor over the Move handle for the control CustomerID text control, until the pointing finger image appears.

13.  Click and drag the control to the immediate right of the CustomerID label control.

14.  Click the CustomerID label control to select it.

15.  Resize the CustomerID label control to fit the new caption (the right border of the control will align approximately with the 3/4-inch point on the horizontal ruler).

16.  Move the CustomerID text control again to adjust its position to the immediate right of the CustomerID label control.

17.  Resize the CustomerID Text control so that its right border aligns approximately with the 1-1/4 inch point on the horizontal ruler).

18.  Click the label control (once again, the left control in the pair) for CompanyName.

19.  Press the Delete key.

The CompanyName label disappears, leaving only the associated text control.

20.  Click the CompanyName text control to select it.

21.  Move the CompanyName text control to the immediate right of the CustomerID text control (aligning it approximately with the 1-1/4 inch point on the horizontal ruler, and to the top of the CustomerID section).

We need, once again, to size the section to ensure that our CustomerID header is presented in compact fashion.

22.  Move the pointer to the bottom of the CustomerID header section, placing it between the CustomerID header section and the OrderDate header section.

The pointer becomes a "double-headed arrow," indicating that it is in position for dragging the CustomerID header section border to the desired position.

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

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

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



MS Access Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




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


















Thanks for your registration, follow us on our social networks to keep up-to-date