All, using access 2016. A user wants a records in a query converted to one line by on cust. Essentially; they want all records related to a particular cust on one line. I've attached an excel dump of a sample of the query and the sample record on one line the way the user wants it. I changed the data to dummy data manually so I may have missed some number to the correct field. I have never done this. Can someone help please.