SMfeecft Awa may result in inconsistent alignment That doesnt look good so if necessary adjust the alignment of the column headings labels as desired generally they should be either all leftaligned or all centered on the sample report I made them all cente

If you need to adjust an individual column width, it may be necessary to turn off control grouping (a new feature in Access 2007). To accomplish this, first select the controls in the Detail section and click the yellow group anchor that should now be visible (though not very visible — Microsoft should have selected a color with more contrast than dull mustard yellow) at the upper-left corner of the group, then right-click any control in the group and select Remove from the Layout submenu (see Figure 1.20).

FIGURE 1.20

Turning off control grouping.

Turning off control grouping.

Figure 1.21 shows the finished worksheet-type report.

You can interactively sort and filter a report in report view— for example, when you want to view records from only one customer, as shown in Figure 1.22.

FIGURE 1.21

A worksheet-type Access report.

Northwind Sales

Order Quarter Customer Order Date Product Price Category

Ql, 1995

Around the Horn

15-Jan-95

Gnocchi di nonna Alice

$508.00

Grains/Cereals

Ql, 1995

Queen Cozinha

04-Jan-95

Mozzarella di Giovann

$291.90

Dairy Products

Ql, 1995

Ernst Handel

23-Jan-95

Mozzarella di Giovann

S56.72

Dairy Products

Ql, 1995

Frankenversand

27-Jan-95

Mozzarella di Giovann

$583.80

Dairy Products

Ql, 1995

Consolidated Holdings

07-Mar-95

Mozzarella di Giovann

$278.00

Dairy Products

Ql, 1995

Victuaillesen stock

30-Mar-95

Mozzarella di Giovann

$1,112.00

Dairy Products

Ql, 1995

Consolidated Holdings

07-Mar-95

Gustaf's Knackebrôd

$201.60

Grains/Cereals

Ql, 1995

Frankenversand

27-Jan-95

Tunnbrôd

$288.00

Grains/Cereals

Ql, 1995

Ernst Handel

02-Feb-95

Tunnbrôd

$432.00

Grains/Cereals

Ql, 1995

Magazzini Alimentan Riuniti

03-Feb-95

Singaporean Hokkien Fried Mee

$22.40

Grains/Cereals

Ql, 1995

Seven Seas Imports

19-Jan-95

FifoMix

$22.40

Grains/Cereals

Ql, 1995

TomsSpezialitaten

17-Mar-95

FîloMix

$8.40

Grains/Cereals

Ql, 1995

Hungry Owl All-Night Grocers

12-Jan-95

Nord-Ost Matjeshering

$37.26

Seafood

Ql, 1995

Split Rail Beer & Ale

02-Jan-95

Gnocchi di nonna Alice

$136.80

Grains/Cereals

Ql, 1995

Ricardo Adocicados

17-Mar-95

Fl0temysost

$34.40

Dairy Products

Ql, 1995

Rattlesnake Canyon Grocery

Ol-Feb-95

Gnocchi di nonna Alice

$2,128.00

Grains/Cereals

Ql, 1995

Galeria del gastrónomo

27-Feb-95

Gnocchi di nonna Alice

$152.00

Grains/Cereals

Ql, 1995

Ernst Handel

02-Mar-95

Gnocchi di nonna Alice

$912.00

Grains/Cereals

Ql, 1995

Princesa Isabel Vinhos

OS-Mar-95

Gnocchi di nonna Alice

$851.20

Grains/Cereals

FIGURE 1.22

Filtering a report by a selected value in the Customer field.

After making the selection, the report shows only Gourmet Lanchonetes records (Figure 1.23).

FIGURE 1.23

A report filtered by a Customer value.

Northwind Sales

Order Quarter Customer Order Date Product Price Category

Ql, 1395

Gourmet Lanchonetes

23-Feb-95

Raclette Courdavault

$830.00

Dairy Products

Ql, 1995

Gourmet Lanchonetes

23-Feb-95

Gorgonzola Telino

$140.00

Dairy Products

Q2,199 S

Gourmet Lanchonetes

24-M ay-9 S

Queso Manchego La Pastora

$30.40

Dairy Products

Q4,1995

Gourmet Lanchonetes

17-NOV-95

Camembert Pierrot

$340.00

Dairy Products

Saturday, October 21,2006 Page 1 of 1

Saturday, October 21,2006 Page 1 of 1

0 0

Post a comment