combining records & concatenating fields

[tonyspain]

The current database has a Code, Sequence No, and Description field. The description field contains only 15 characters that is why there are multiple records with the same code. I want to concatenate the description fields with then same Code and ascending Sequence No.
Can I do this with a query? Thanks.

 

[dhookom]

tonyspain,
Can you provide some sample records with table and field names as well as how you expect this to display in your query?

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]