I have an Access Query in which I would like to combine fields within the same data-record so that multiple rows are not produced. This happens because there is one field that could have more than one input and thus creates a new row for each of those inputs (with mostly duplicate information).
I've attached a spreadsheet that should give you an idea of exactly what I'm talking about. Note that Client 3 has multiple License Numbers and thus creates multiple Rows in the report. Can I combine this so that only one row is produced per client (with commas separating each License Number)?
If anyone could walk me through the steps on how to do this, it would be most appreciated.