This should be so easy, why isn't it?

[lizlathan]

Newbie here. Been banging my head on this for 3 days. I have a query (QryLiz) drawing from two tables (dbo_tblVisitAttendee and dbo_tblVisit), and I need some sort of module or expression to concatonate the attendee's titles (from dbo_tblVisitAttendee) into one line. I've found a couple of examples that I think I can edit to do this:

Instead of:
Sprint CIO
Sprint Manager
Sprint Director

I want:
Sprint CIO, Manager, Director

But once I put the code into a module and save it, what do I do with the module? Do I pick it from the "Build" tool on a Query? Arg. I know I'm making this way harder than it is!

Thanks so much,
Liz

 

[ghudson]

If I understand you correctly all you need to do is add a new field in your query to pull the data fields together.

Title: [Title1] & ", " & [Title2] & ", " & [Title3]

 

[lizlathan]

But I don't have a Title1, Title2, etc. columns, I just have one Title column. The goal is to to put the columns into one field in the row...