I have some data that I am trying to summarize and I am thinking I will need a union query to achieve it but I am not sure. I am not that strong with union Queries so any suggestions are appreciated. My data set is as follows
From dbo_SHIPMENT_DETAIL
ORDER LINE PART_ID...