I need to split out information in a report and I'm not sure how to do it.
The report is based on the following query:
SELECT tblHazardClass.HazardClass, Product.ProductName, Product.Package, Product.Size, tblStoreProducts.Cases, Product.Units, Product.ReportUnits...