Attached is a database.
I need a report like 'Report - Shipping by week (detail by freight)' this report is basedd on the "Query: Orders to ship" but instead of printing all orders at once like in the aforementioned report, I need the following.
1. I'd like the database to prompt me for the Cust_PO that I'd like to print.
2. When I enter the PO, I'd like the database to print a report, in a 4x6 sheet, and the report will include the following fields
PO: "Cust_PO"
Shipping Date: "Shipping_Date"
Ship via: "Ship_Via_Company"
Customer: "Cust_Name"
"Ship City", "Ship_State"
Then, I need the report to list the items ordered on the particular PO
Quantity - Item - Box
Subform_qty - Item_ID - Box_type
But the list only can have the maximum number of trays that a particular box_type can hold. So first the items for a the entered Cust_PO needs to be grouped in Box_type. So all the items with a box_type of Box23, they need to be group in one page. If that page does not exceed the Trays_per_box then, it can print all the items in that page, if not, it needs to print the remaining items in another page, until it prints them all.
The number of trays is already calculated in the "Query: Orders to ship", the calculation is Trays: [Subform_qty]/[Tray]
Once it has listed all the items for all box types, then it's done.
A label can only be for one box type.
Does this make sense? I need this to be done asap.
Thanks!
daniel