×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

How to print a report with a separate customer copy and then the same with an office copy footer

How to print a report with a separate customer copy and then the same with an office copy footer

How to print a report with a separate customer copy and then the same with an office copy footer

(OP)
Hello Everyone: I have been searching, but cannot find an answer for this. How can I print one report, many times but with a different footer . Each footer would have a different word, such as "customer copy", "office copy", "admin copy", etc?

Thank you,
Sophia

RE: How to print a report with a separate customer copy and then the same with an office copy footer

Create a small table [tblCopies] and a single short text field [Copy] and add the values: Customer, Office, and Admin.

Then add this table to your report's record source query but don't join it to any other table. This will actually create 3 times the number of records in your query.

Set the primary sorting and grouping of your report to the [Copy] field and possibly add group header and footer sections. In the footer section of this [Copy] group add a text box with this control source:
=[Copy] & " copy"

You will probably want to remove all of your existing Report Header and Footer controls and place them in the [Copy] Header and Footer sections.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

RE: How to print a report with a separate customer copy and then the same with an office copy footer

(OP)
Thank you very much Duane! I had the table, but for some reason could not get the desired result . I changed =[Copy] & " copy" to just the [copy], since it would not work otherwise.

I appreciate your help!
Sophia

RE: How to print a report with a separate customer copy and then the same with an office copy footer

The =[Copy] & " copy" would work if you change the name of the text box to txtCopy.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

RE: How to print a report with a separate customer copy and then the same with an office copy footer

(OP)
Ok, I understand now. Or I could just name it "Customer copy", etc, right?
Sophia

RE: How to print a report with a separate customer copy and then the same with an office copy footer

You can name the text box whatever you want. The key is to not use a field name as the name of the control if the control source begins with "=".

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close