Printing report with different customer names

[Sherryg]

I am creating a report with pricing for specific customers. There may be up
to 50 different customers for each pricing group. Can Access print the 50
reports, each reflecting the respective company name as a part of the Header?
In other words, I don't want to manually change the header for each company.
I want Access to use my table of customer names for that pricing group and
generate the "customized" (50 different personalized company) reports with
one click of the Print command.

 

[Allen Browne]

The answer will depend on how you have set up your tables.

Let's assume you have tables like this:
CustomerGroup table (one level for each pricing tier):
CustomerGroupID primary key

Customer table (one record for each customer):
CustomerID primary key
CustomerName text
CustomerGroupID relates to CustomerGroup.CustomerGroupID

Product table (one record for each product):
ProductID primary key
ProductName text

ProductPrice table (one record for each combination of product and pricing
tier):
ProductID relates to Product.ProductID
CustomerGroupID relates to CustomerGroup.CustomerGroupID
ProductPrice Currency

You can now create a query using all 4 tables, and make a report to do what
you want.

In report design view, open the Sorting And Grouping dialog (View menu.)
Choose the CustomerID field, and create a Group Header. Set the Force New
Page property to Before Section so each customer's list starts on a new
page.

 

[Sherryg]

Thank you! My tables are already established. I "acquired" this after they
were loaded in Access. I can rework them to meet the requirements but may
have further questions on the query.