Split and Concatenate

[jw5107]

I have a table that houses the data like so:

GTWY LMPer
ABQ J.C. Weis (757)
ABQ Lori Stewart (767)
ABQ Darin Muhs (A300)

How can I get the data to look like this:

GTWY LMPer
ABQ J.C. Weis (757)
Lori Stewart (767)
Darin Muhs (A300)

Meaning the taking it from 3 records down to 1.
I have been working with:
Expr1: IIf(Nz([LMPer])<>"",[LMPer] & Chr(13) & Chr(10))
but not able to group and concatenate.

Any suggestions or examples??

Thanks in advance!!
jw

 

[dhookom]

You could do this in a report where you hide duplicates. Otherwise, there is a generic concatenate function and sample usage at

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]