lynp

Thank you for your reply Jerry, While the solution did not work for me it did lead me in the right direction and problem solved!

I am at a loss here. I need to create a packing list that states how many packages have a certain quantity in them. For example: there are 10 packages. Nine packages contain 1000 items, one package contains 750 items. My packing list needs to state this information: Total Quantity = 9750 Total packages shipped = 10 9 packages of 1000 1 package of 750 I can figure out how to list this using a self joining relationship and a portal but I need the individual values (9 at 1000 and 1 at 750). help??

I have a label database that creates labels based on the total number items and the number of items per package (i.e., 3200 total items, packaged 750 per box yields 4 boxes of 750 and one box of 200) I need to create a packing list summarizing; 4 boxes at 750 1 box at 200 I am not able to noodle this one out! I am able to use a 'self join' relationship which tells me I have 2 unique values (1=750, 1=200) but won't tell me that I have 4 at 750 and 1 at 200 and I am able to create a table that gives me the correct sub summary (4@750, 1@200) but I don't know how to put the sub-summary field onto a separate form. Help??

I am trying to create a script to print box labels. I want the user to enter in how many boxes of "a" quantity, how many boxes at "b" and how many boxes at "c" quantity. For example; 3 boxes at 1000, 1 box at 950 and 1 box at 275. This would create single shipment of 5 boxes. I need my script to create 5 box labels with the following information; "box 1 of 5, quantity 1000; box 2 of 5, quantity 1000; box 3 of 5, quantity 1000; box 4 of 5, quantity 950, box 5 of 5, quantity 275" Any suggestions??