March 23, 201312 yr Newbies 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??
March 25, 201312 yr 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?
Create an account or sign in to comment