columns and headings

[Guest]

I have created a database for workorders and items on those workorders that
have to be invoiced when they workorder is done. I would like to create a
report that has the items going down th side and the workorder # & address at
the top. I would like the report to expand on the page as it fills with
workorders.

I have created a report that sort of does this, except that it repeats the
items that are along the side in every column, I only want the items to show
once on every page of the report, down the left hand side. What am I doing
wrong?

 

[David Austria]

Hello. I recommend the following Link:

ACC: Page Header That Spans Full Width of Multi-Column Report
http://support.microsoft.com/kb/90870/en-us

In Microsoft Access 1.x and 2.0, to create a grouped, multiple-column
report where the page header spans the width of the page, follow these
steps:

1. In report Design view, drag the right edge of any report section to
the desired width of the report. For this example, drag the edge over
to the 7 inch mark on the ruler.
2. Choose Sorting and Grouping from the View menu and enter a field or
expression in the Field/Expression box to group your data by.
3. In the Group Properties section of the Sorting and Grouping dialog
box, enter Yes for Group Header.
4. Using the Toolbox, create a Label and place it in the page header.
Enter the text for the label in the Caption property. Size the text box
so that it is the same width as the page header.
5. Using the Toolbox, add a text box bound to the group field. Position
the text box in the group header. Size this control 2 inches wide or
less, and place the left edge of the box along the left edge of the
group section.
6. In the detail section place your bound control(s) within the first 2
inches.
7. From the File menu, choose Print Setup.
8. In the Print Setup dialog box, choose the More button.
9. In the Items Across box, type the number of columns you want in the
detail section. For this example, enter 3. Leave row and column spacing
as they are.
10. In the Item Size section, clear the Same As Detail check box.
11. In the Width box, type the number of inches you want to allow for
each column of data. For this example, enter 2.
12. Under Item Layout, select Vertical. This creates a snaking column
report. Choose OK.
13. Click the group header section to display the property sheet. For
the NewRowOrCol property, choose Before Section. This causes the group
header to be printed at the top of the column one time for each new
group. Print or Preview the report.

Greetings
David Austria