Hi All,

I am in a process of trying to concatenate related fields field in Access.
eg: consider the following table

Awarded to On Date
Emp1 01/01/1990
Emp2 02/01/1990
Emp1 03/01/1990
Emp3 04/01/1990
Emp2 05/01/1990

I want my query to return something like:
Awarded to On Date
Emp1 01/01/1990, 03/01/1990
Emp2 02/01/1990, 05/01/1990
Emp3 04/01/1990

for this purpose I am using, Allen Browne's function ConcateRelated(....) from the following location.
http://allenbrowne.com/func-concat.html

I use the function as ConcatRelated("[On Date]","[Table]","Awarded to = " & """ & [Awarded to] & """)

This doesnot work for me and I get an error

Set rs = DBEngine(0)(0).OpenRecordset(strSql, dbOpenDynaset)

not sure what am I doing wrong.

Thanks in advance.

Error is Syntax error (missing operator) in query expression 'Awarded to =" & [Awarded to] &"'