Member Avatar for keeda

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.

  • 1 Contributor
  • 1 Reply
  • 162 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by keeda
Member Avatar for keeda

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.