Results 1 to 2 of 2
Thread: Numbered Labels (2003 allSPs)
2006-11-04, 04:50 #1
- 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
SteveDummy from Down Under <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>
2006-11-04, 14:03 #2
- Join Date
- Jun 2001
- Crystal Beach, FL, Florida, USA
- Thanked 37 Times in 36 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".