I'm wondering if there is a way to do the following in a query:
We have a small project management database that we use for tracking updates on projects. Each update is a separate record in a table called tblUpdates. The updates are linked to the project based on a unique project ID called "CPOProjectNum".
What I would like to do is create a query that would concatenate all of the "Description" fields for each update record for a given project into one large field. This query would be exported to Excel so that each project would be on one line and all updates would be contained in one cell.
Does that make sense? Is there a way to accomplish it?
We have a small project management database that we use for tracking updates on projects. Each update is a separate record in a table called tblUpdates. The updates are linked to the project based on a unique project ID called "CPOProjectNum".
What I would like to do is create a query that would concatenate all of the "Description" fields for each update record for a given project into one large field. This query would be exported to Excel so that each project would be on one line and all updates would be contained in one cell.
Does that make sense? Is there a way to accomplish it?
