|
Try This: Do the following steps
2. Open the
CustomerCompanySQ Query. When prompted, enter the company Wordnation.
3. Open the
Query in Design View.
4. Add a
new field. Add the following Concatentation:
Location: [City]&, &[State]
5. Run the
Query to test the new field. Use the Parameter Pest People when prompted.
6. Create a
new Report using the Report Wizard. Use the Query CustomerCompanySQ as
the Record Source. Select all available fields.
7. Add a
Grouping level: Company. Select a layout: Stepped.
8. Name the
Report: Customer Name. Select Preview and Finish the Wizard.
Use the
Parameter Pest People when prompted.
9. Close
Print Preview. Open the Report in Layout View.
10. Select
all the Fields in the Detail Section. Change the arrangement to
Tabular.
11. Go to
Arrange Rows & Columns and Insert 2 new Rows above.
12.
Select the CustomerID Control in the Table. Use the
Move Up command to place the Field in the top Row.
13.
Move these
Fields up to the second Row: Phone
Number and Location.
14. Use the
Table Tools to Merge the Cells.
Select the three Cells next to CustomerID in Row 1: Cells
A2:A4. Merge them.
15. Go
to the Page Header and Delete
the Labels EXCEPT the Label for Company. Change Company to The
taste of eating out, the price of brown bagging it.
16. Go to
the Report Header. Change Customer Name to Brown Bag Lunch Co.
17. Select
the second Row, with the company name Wordnation and apply a top
gridline.
18. Save
the Customer Name Report. Please close the Brown Bag database. |
|
| |
