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.