By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,139 Members | 1,247 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,139 IT Pros & Developers. It's quick & easy.

Complex label question

P: n/a
Hello I need to create labels for the following data:

PlaceName table :
Fields: PlaceID, PlaceName (i.e. USA), Last label Number Used(This will be used to determine the
starting point for a "NewNumber" field--which I do not know where to put yet)

Details table: TestID, TestDigit (.01-.20), Description--joined on place ID
There are 20 test numbers for each "Place"

What I need to do is create sets of labels like below:

PlaceName NewNumber.TestDigit
Description

I need to create a finite set (15 at a time) of new records for the "New Number" field so I can
print out 20 labels (the 20 different digits) each for the 15 new numbers--
USA. Newnumber1. Testdigit1
USA. Newnumber1. Testdigit2
USA. Newnumber1. Testdigit3, etc

USA. Newnumber2. Testdigit1
USA. Newnumber2. Testdigit2
USA. Newnumber2. Testdigit3, etc
I have a query set up between the 2 tables to pull the needed info together and then can base a
label report on that--but the issue is how do I create the new records for the NEW NUmber Field and
where do I store this new number field? In a separate temprorary table? If so, how do I populate
that table and then clear it out afterwards?
Any help would be greatly appreciated

Thank you

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Sun, 26 Oct 2003 01:03:04 GMT, al*****@cox.net wrote:
Hello I need to create labels for the following data:

PlaceName table :
Fields: PlaceID, PlaceName (i.e. USA), Last label Number Used(This will be used to determine the
starting point for a "NewNumber" field--which I do not know where to put yet)

Details table: TestID, TestDigit (.01-.20), Description--joined on place ID
There are 20 test numbers for each "Place"

What I need to do is create sets of labels like below:

PlaceName NewNumber.TestDigit
Description

I need to create a finite set (15 at a time) of new records for the "New Number" field so I can
print out 20 labels (the 20 different digits) each for the 15 new numbers--
USA. Newnumber1. Testdigit1
USA. Newnumber1. Testdigit2
USA. Newnumber1. Testdigit3, etc

USA. Newnumber2. Testdigit1
USA. Newnumber2. Testdigit2
USA. Newnumber2. Testdigit3, etc
I have a query set up between the 2 tables to pull the needed info together and then can base a
label report on that--but the issue is how do I create the new records for the NEW NUmber Field and
where do I store this new number field? In a separate temprorary table? If so, how do I populate
that table and then clear it out afterwards?
Any help would be greatly appreciated

Thank you


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.