combining rows

[agonzalez]

I have what is probably a simple thing to do in a qry but I just can't figure it out.

I have a spreadsheet that I imported into access. The basis of this spreadsheet is just basic company info.

Company|Address|City|State|Zip|Name
AAA Comp|123 Street|Anywhere|CA|90210|Mr. Somebody
ABC Comp|345 Street|Anywhere|CA|90210|Ms. Somebody
ABC Comp|345 Street|Anywhere|CA|90210|Ms. Anybody
ABC Comp|345 Street|Anywhere|CA|90210|Mr. Anywho
XYZ Comp|678 Street|Anywhere|CA|90210|Mr. Whosthat

For some companies, the information will repeat, like ABC Comp. What I need to do is to combine the rows with the same company information ie:

Company|Address|City|State|Zip|Name
AAA Comp|123 Street|Anywhere|CA|90210|Mr. Somebody
ABC Comp|345 Street|Anywhere|CA|90210|Ms. Somebody, Ms. Anybody, Mr. Anywho
XYZ Comp|678 Street|Anywhere|CA|90210|Mr. Whosthat|Pres.

Is there a way to do this in a qry?

Thanks in advance!

 

[neileg]

Fairly easy to do in a form or report. Do you really need to do this in a query?

 

[agonzalez]

Yes, I actually do need this in a query. I will have to send this to our pprinting house with the shipping information in a spreadsheet form. We only need one address label for all the people receiving the book. The attn line will be long, but that is the way we are supposed to do it.

 

[Cosmos75]

Maybe this can help - DConcat function - Concatenating field values for multiple records matching a query's GROUP / SORT BY or WHERE clause