I have a Access 2003 query that pulls fields from several tables. One field in the query can be associated multiple times with a master record. What I need is the multiple records in this one field be combined into one field in the query so I do not have the master record info duplicated. I have an attached db to better see what I currently have.
The EmailQuery is the one I need modified. If you view the query you will see that I have different entries in the TopicName and Issue ID field. Basically what I need is something like if Issue ID matches I only need one record with all Topic names combined in one field. So the existing query which now has 4 items would be cut down to two items for each different Associate ID with is the master record.
Hopefully that all makes sense.
## Deliverables
I believe I posted all the info in the original description. Access 2003 Database that will be running on Windows 2003 Server for an ASP backend.
The "EmailQuery" is the only Query I need modified with this project.