The senario is Order with the items in a 'Detail' table.

I have a need concat the detail (Quantity and Productname +crlf) into one
field and return it with a query of the Order table.
This is so I can have the order information and the detailed line items in
a text 'memo' field.

Otherwise you end up with multiple records when joining items and order tables.