Make up numbers based on quantity

  • Thread starter Thread starter Mike Revis
  • Start date Start date
M

Mike Revis

I really don't know what the subject should be.
Hi Group
Access 2000 WinXPpro

I have one textbox on my report that is supposed to show the quantity of
packages and content of the packages.

Simple example output:
1 box contains 4 bats
1 box contains 4 balls

When those two boxes are packed in an overpack it has to read:
1 box contains 4 bats
1 box contains 4 balls
Overpack Used

This means 1 box contains 1 box with 4 bats and 1 box with 4 balls

If there are 10 identical overpacks it would have to read
1 box contains 4 bats
1 box contains 4 balls
Overpack Used X 10

This means 10 boxes each contain 1 box with 4 bats and 1 box with 4 balls

Having said all of that. That was the easy part. I can produce that much.

Now I have to number the overpacks.
1 box contains 4 bats
1 box contains 4 balls
Overpack Used X 10
#1, #2, #3, #4, #5, #6, #7, #8, #9, #10

The total quantity of overpacks can be any quantity.
If there were only 3 overpacks then there would only be 3 #'s and so on.

I don't have even a clue where to begin with that part.

Then to make it worse I have to state the total quantity per overpack.

1 box contains 4 bats
1 box contains 4 balls
Overpack Used X 10
#1, #2, #3, #4, #5, #6, #7, #8, #9, #10
Total net quantity per overpack
4 bats, 4 balls.

If you think this a joke you aren't keeping up on your US government
regulations.

As always any advice, suggestions or thoughts are much appreciated.

Mike
 
You say, " Now I have to number the overpacks"... Does this mean ALWAYS #1
through #n, where there are n overpacks? Or is there some other way that the
numbers are arrived at?

If the first, you should be able to generate the sequence of numbers with a
For statement in the Print event, given that you have the number of
overpacks available.

Larry Linson
Microsoft Access MVP
 
Thanks for your response Larry.
The numbers can be any combination of letters and numbers or just numbers.
It doesn't matter what the numbers are. They are just for unique
identification purposes.

Mike
 
Back
Top