concatenate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Afia said:
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
Click to expand...


Did you copy/import the function's module into your
application?
 
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


Marshall Barton said:
Afia said:
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
Click to expand...


Did you copy/import the function's module into your
application?
Click to expand...
 
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


Marshall Barton said:
Afia said:
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
Click to expand...


Did you copy/import the function's module into your
application?
Click to expand...
 
Back
Top