Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Now-Luanda, Angola, Originally - Anna Bay, New South Wales, Australia
    Thanked 0 Times in 0 Posts

    Numbered Labels (2003 allSPs)

    I need to be able to produce shipping labels for many crates that would have name and address as well as Crate 23 of 345, Crate 24 of 345 etc. I also need to be able to specify how many labels for each person eg Fred may have 150 crates while Mary may have 400.
    Any help appreciated
    Dummy from Down Under <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Crystal Beach, FL, Florida, USA
    Thanked 41 Times in 40 Posts

    Re: Numbered Labels (2003 allSPs)

    You need to have a separate tblNumbers table (call it what you want). There is only 1 field (an integer), and you just add sequential number to the table; from 1 to as many as you might ever need.

    The query behind your label report must include this table. Because it doesn't have a join to the other tables, Access creates what is called a Cartesian join. This would create as many labels for each unique name/address as there were records in tblNumbers. You can use a WHERE clause to restrict how many to use, in your case tied to that "# of Crates".
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts