Jeff,
Let me try this again. This is really important and I'm trying to figure
out if it something I have to do in VBA or if it something that can easily be
done within the Report program within Access. The hierarchy of my report is:
Sort By: Customer - Product Group - Product
Group By: Customer - Product Group
This is how my report prints right now:
{No Report Header
Customer Name {Customer Header Fields
Address
City, State zip
Phone
Product Q1 Q2 Q3 Q4 {Customer Header Labels
ProductX xx xx xx xx {Detail Records
[Page 2, Same Customer]
Product Q1 Q2 Q3 Q4 {Page Header
ProductX xx xx xx xx {Detail Records
[Page 3, New Customer]
Product Q1 Q2 Q3 Q4 {Page Header
Customer Name {Customer Header Fields
Address
City, State zip
Phone
Product Q1 Q2 Q3 Q4 {Customer Header Labels
ProductX xx xx xx xx {Detail Records
And therein is my problem. Because the page header prints on the new page
AND my Customer Header prints because it is a new customer, my column
headings print twice. I want my page three to look like this for a new
customer:
[Page 3, New Customer]
Customer Name {Customer Header Fields
Address
City, State zip
Phone
Product Q1 Q2 Q3 Q4 {Customer Header Labels
ProductX xx xx xx xx {Detail Records
Thanks for your quick response.
Tom
Jeff Boyce said:
Sorry, but I'm still confused. Your example of how you want it to look when
the customer changes:
Product Q1 Q2 Q3 Q4
Detail Records XX XX XX XX
Customer Information
Product Q1 Q2 Q3 Q4
Detail Records XX XX XX XX
includes what I would describe as "detail" info BEFORE your (new) customer
information. How does that work?
<see additional comments in-line below>
Regards
Jeff Boyce
<Office/Access MVP>
Thanks Jeff for your fast response!
To preserve printing space on the report, here is the hierarchy of my
report.
Sort By: Customer - Product Group - Product
Group By: Customer - Product Group
Within the Customer Header, I have the first page of column headings
defined:
Product Q1 Q2 Q3 Q4
Detail Records XX XX XX XX
I don't see the customer information here, in what you've described as the
Customer Header.
If the detail spills over to a second page, I just want the fields
identified above to print on pages 2, 3 etc.
When the customer changes, then a new page prints and my Page Header and
my
customer Header print. It looks something like this:
I don't understand ... what information are you placing in the Page Header?
Product Q1 Q2 Q3 Q4
Detail Records XX XX XX XX
Customer Information
Product Q1 Q2 Q3 Q4
Detail Records XX XX XX XX
On the new customer information page, I want it to look like this:
Is this a repeat of what you just said above?
Customer Information
Product Q1 Q2 Q3 Q4
Detail Records XX XX XX XX
<New page continuation within same customer>
Product Q1 Q2 Q3 Q4
Detail Records XX XX XX XX
:
I may not fully understand your report design. If you have changing
customer, plus details for each customer, couldn't you put the customer
"header" information in the Customer header? This assumes you have
grouped
by Customer.
What am I missing?
--
Regards
Jeff Boyce
<Office/Access MVP>
I have an Access report that provides information by customer and a
number
of
pages of detail that will follow. I want to create a common look to
the
first page, but on the second pages and following I want to display
the
column headings that I've defined within my Page header section of the
report. Every time the customer chages, I want the customer header to
display, but not the page header. Access indicates that there is only
3
groupings that control the Page Header -- Print With Report header,
Print
with Report Footer, and don't print with either. How do I do this?
Thank
you in advance.
