concatenate

[Afia]

Can someone please let me know what's wrong with the code below, please:
DCType: Concatenate("SELECT DCType FROM Sitesinscope WHERE NasmCode =" &
[NasmCode]). I have looked at Duane Hookom's library and it the code makes
sense but when I tri in my db I get error message "Undefined function
'Concantenate' in expression

 

[Marshall Barton]

Can someone please let me know what's wrong with the code below, please:
DCType: Concatenate("SELECT DCType FROM Sitesinscope WHERE NasmCode =" &
[NasmCode]). I have looked at Duane Hookom's library and it the code makes
sense but when I tri in my db I get error message "Undefined function
'Concantenate' in expression

Did you copy/import the function's module into your
application?

 

[Afia]

Marshall, Thank you for your reply.
The tables are linked to Access from an sql db. I'm running various queries
to map the information so can create reports in Access.
I don't think I import the function module in, please advise how to do it,
is it Access add-in?

--
Afia

Can someone please let me know what's wrong with the code below, please:
DCType: Concatenate("SELECT DCType FROM Sitesinscope WHERE NasmCode =" &
[NasmCode]). I have looked at Duane Hookom's library and it the code makes
sense but when I tri in my db I get error message "Undefined function
'Concantenate' in expression

Did you copy/import the function's module into your
application?

 

[Afia]

Hi Marsh

ignore my previous post, read your reply few times and it makes sense, I
have managed to get it working, A big thank you to Dune and you both.
--
Afia

Can someone please let me know what's wrong with the code below, please:
DCType: Concatenate("SELECT DCType FROM Sitesinscope WHERE NasmCode =" &
[NasmCode]). I have looked at Duane Hookom's library and it the code makes
sense but when I tri in my db I get error message "Undefined function
'Concantenate' in expression

Did you copy/import the function's module into your
application?