Concatenate is not working right

A

Alex

I have the below expression in my query, along with the module from Duane
Hookoms function. I have three records with the same badge number, but the
comments fields in query results lists the comments from the 1st record in
all three records. It's still non concatenating. Any idea what I'm doing
wrong? Thanks.

Comments: Concatenate("SELECT Comment from tbl_Information WHERE Badge=""" &
[Badge] & """")
 

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

Combine field from several records 14
Converting URLs in comments to Markdown-formatted links 2
Concatenate function from a Query, not a table 5
Concatenate Problems 12
Concatenate many to one 5
Concatenate Error: It's just blank! 1
Mailmerge Skipping Names in List.... 1
Concatenate same field records into one. 14

Top