L
Laurie
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!
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!