I need to be able to produce 1000 labels from access that are based on consecutive numbers that Access will produce.
Here are some of the criteria they are looking for:
- Need to be able to produce labels on demand – generating at least 1,000 labels at a time.
- The program will know what the last number used was so when they print the next batch of labels it will automatically know.
- A table called NumberTable with one field called Number set at a Number Data Type.
- I have a query called AddNumberQuery that is based off the table. It has the Number field in it and a calculated field which is Number +1.
My problem is – is that I am not the greatest at code and could use some assistance.
If you have an easier way to do this I would welcome any suggestions. Once I have the data created I can create the report on my own.
Thanks
bwesenberg