Merging Fields in a query

S

Sherri Dean

Hi,
I am self-taught on Access, so please forgive my ignorance here.

I have a subform that allows for multiple selections from a table, one
line/field per selection. So when I run a query that selects for that
information, I get an entry for that person for each item that has been
selected in that subform. I understand why it is doing this, but am
wondering if there is a way to write the query so that it can combine any
items selected into one row.

Example of how the query works now:
Col1 col2 col3 col4
NameA choice1 otherinfo etc
NameA choice2 otherinfo etc

I would like it to show:
Col1 col2 col3 col4
NameA choice1, choice2 otherinfo etc

Thanks in advance!
 

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

Similar Threads

Query the brings only 0 value 5
Sum specific row values 1
Q re Subqueries (Join Predicate) in Access 10
duplicate rows returned in query with inner join and where clause 3
Need help with my query for comparing two tables?! 1
Query that also includes records with NULL values 3
Changing Data Type of Column in Query. 1
Update datarow 2

Top