Concatenate undefined function

[BH]

Hi

It has been a while since I used Access and can't get round a concatenate query problem I have.

I am trying to concatenate a field (service) for all records that have the same identifier. The query I have wrote is:

ServiceArea: Concatenate("SELECT [Service] FROM tblStudies WHERE [Identifier]='" & [Identifier] & "'")

The message I am getting is "undefined function 'concatenate' in expression"

I would really appreciate some guidance so thank you in advance.

 

[MajP]

No single function in Access to do that
Take a look at faq702-4233

 

[BH]

Brilliant! Thank you MajP for pointing me in the right direction. Worked a treat!