Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Printing one label for multiple records

Discussion in 'Information Technology' started by dharman, Jul 28, 2006.

  1. dharman

    dharman
    Expand Collapse
    Guest

    I am trying to print one label that will include data from multiple
    records. I have generated a query where each record has some common
    fields and some unique fields. Can a label be generated through
    reports that will pull the common info once and the unique fields
    multiple times? What am I missing?
     
  2. Loading...

    Similar Threads Forum Date
    Controversial War over Private Printing of "Birs" Intensifies Hard Talk Jul 9, 2011
    Nations Finally Agree on GM Food Labeling Health & Nutrition Jul 6, 2011
    Akal Takht Jathedar Labels Pal Singh Purewal as an Agent of RSS Hard Talk Feb 20, 2011
    The Prison of One-Word Labels Sikh Sikhi Sikhism Nov 18, 2009
    Sikh News Sikh community unfairly labelled 'terrorists' after Air India bombing, inquiry told ( Breaking News Dec 8, 2007

  3. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    Guest

    Yes.

    Create a report and bring in all the fields you want to include in the
    report/lable.
    At the top of the screen click the sorting button and select the field you
    want to use as your "common info"
    Ensure you select the group header and footer options in this box to "yes"
    Close this menu.
    Drag the "common info" object into the field header area of the screen.
    Arrange the rest of the fields in the Detail section of the screen
    View the report.

    Is this what you are looking for if not let me know.


    --
    Wayne




    "dharman" wrote:

    > I am trying to print one label that will include data from multiple
    > records. I have generated a query where each record has some common
    > fields and some unique fields. Can a label be generated through
    > reports that will pull the common info once and the unique fields
    > multiple times? What am I missing?
    >
    >
     
  4. dharman

    dharman
    Expand Collapse
    Guest

    I am able to see the results I need in a report. I just can not get
    the results for a label, which is what I need. Is this possible?
     
  5. Rick Wannall

    Rick Wannall
    Expand Collapse
    Guest

    In every way, a label is in fact just a report with a little bitty page
    size. When you say that you cannot see what you want in a label, are you
    saying that the Access report you are using to print your label will not
    show the same thing as some other Access report you use to print the same
    thing?
     

Share This Page