Change page heading based on footer value

B

Bill Phillips

I have a report that creates 2 sections for each customer. Section 1 is On
Order, section 2 is Invoiced. I total the two together and to get a subtotal
for each customer. I did this by sorting & grouping and I have a force new
page after each section.

My problem is that I want the page header for the customer subtotal to say:
"Subtotal for Customer ABC". I know how to program the variable info in the
page header, what I don't know how to do is tell Access when to format the
page htat way.

I'm quite sure I need an on Format event. When a footer prints is there a
value that is changed during the format step that I can reference in my
headre field?

Thanks in advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Section and Page numbering 0
Use "Next Page Break" instead of "Page Break" on the cover page. 0
Cover Page - Use "Next Page Break" rather then Page Break 0
Mail Merge Directory Conditional Page Break 0
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Footer On Last Page Only Not Working 1
How to bulk add section breaks after a particular combination of letters/numbers 0
Space at end of multi page list to accommodate new entries 1

Top