Summarize number of packages containing unique quantities

[lynp]

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??

[Adam M.]

There are many ways to skin a cat (why anyone is skinning cats is beyond me...).  The solution would depend on your tables.  What tables are you using and how are you getting this "750" & "200" sub summary?  Is it a summary field from child items for the package?