Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Reports / Printing / March 2005

Tip: Looking for answers? Try searching our database.

Make up numbers based on quantity

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mike Revis - 28 Mar 2005 03:09 GMT
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
Larry  Linson - 28 Mar 2005 04:29 GMT
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

> I really don't know what the subject should be.
> Hi Group
[quoted text clipped - 49 lines]
>
> Mike
Mike Revis - 28 Mar 2005 16:06 GMT
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

> 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
[quoted text clipped - 60 lines]
> >
> > Mike
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.