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