Merge Field Values from Different Records for Report with a Comma



Hello all,

We have Access 2000 - old school.

I know enough Access to be dangerous and I'm ok with queries but new to SQL
queries. This problem has me (and others) confused but is probably easy to

I have two tables with a “one to many†relationship. Since I do
environmental work, I'll use Streams and Violations for my example. The
Stream table (parent) has a unique ID with individual stream names. The
stream table is linked using the unique ID to the Violation table which has
separate Violations in each record.

Field Names: Unique_ID StreamName Unique_ID Violation
Value R0001 Pine Creek R0001

R0001 Pathogen

R0001 Heavy Metal

I need to either create a report or a query (to later make a report) that
will output the data by each stream and then each violation separated by a

Stream Name Violation
Pine Ceek Trash, Pathogen, Heavy Metal

Any help will be most appreciated!


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question