Ok title may not be clear but....

I have a main form that holds the Delivery request details and for each delivery request I may have multiple items going out and  for each item I have to record the Asset number and/or Serial number.

I have a products sub form in my main table that I can add the product name (default qty is 1), the serial number and the asset number.

I need a report so I can run a daily dispatch report, that details  a row for each product shipped and certain required fields from the main form, so in theory I could have several rows with the same request reference, PO, address, contact name but the columns for product description, asset no and serial no. will vary accordingly

I hope this makes sense and someone can help me in how I can accomplish my report, which I will need ot output to Excel as well (so each asset number and serial number is in a separate cell)

Kind Regards

Matt