Concatenate many records into a text field

[kimmer7389]

I am trying to Concatenate many records into a single text field on a report.

I have 2 tables.

tbl_Procedures
PK - ProcedureID - Autonumber
Procedure - Text

tbl_ProcSedationFinal
PK - MRN - Number
Procedure - Number

I would like for all the procedures to be listed in a text field on a report and it would look something like this:

Procedure 1, Procedure 2, procedure 3

I am using the example found at

http://allenbrowne.com/func-concat.html

In the text field on the report I am using an expression for the source and it looks like this:
=ConcatRelated("ProcedureID","tbl_Procedures","Procedure = " & [ProcedureID])

This isn't working though. I keep getting the popup asking me to enter a parameter value for ProcedureID. And then I get an error message that says "Error 3075: Syntax error (missing operator) in query expression 'Procedure='"

I know I am probably missing something simple like a quotation or a comma but I am at my wits end.

Thanks for your help
Kim

 

[dhookom]

I would just use the code at faq701-4233. If you can't figure this out, come back with questions and describe your table relationships.

Duane
Hook'D on Access
MS Access MVP

 

[kimmer7389]

Thanks for the function.

I can't seem to get the expression to work in a textfield on a report.

 

[dhookom]

I can't seem to see the expression you tried, your table relationships, or your reports record source.

Duane
Hook'D on Access
MS Access MVP