Hello,

I have multiple rows of schools that are in the same building. For each
building, I want to concatenate each school name and put a pipe (|) between
each one.

I found this link (I was planning on working out the pipe (|) bit later):
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

I tried to copy and convert his names to my names, but I'm getting an error
message: "Undefined function "Concatenate" in expression."

I'm sure that the answer is right in front of me and I am being a bit daft,
but does anyone have a solution for me?

My rows look like this:  

Primary_Building_Code    Location_Name
K1    School A
K2    School B
K2    School C
M3    School D
M3    School E

I want them to look like this:
Primary_Building_Code    Schools in Building
K1    School A
K2    School B | School C
M3    School D | School E

Here's my code:
Schools in Building: Concatenate("SELECT Location_Name FROM 2006-2007
Schools Web Data WHERE Primary_Building_Code = " & [Primary_Building_Code])

Thanks ever so much!