Concatenate Problems

[JKarchner]

I am trying to concatenate a field in a list of records. I have used the
sample given be Duane Hookom. When i try to type the expression for a
concatenation i receive an error that says that concatenate is an undefined
function, but when i copy and paste the code from Word, i receive a syntax
error on the first field in the concatenation section.
The code I am using:
SELECT Suppliers.Supplier, Reports.Report, Concatenate("SELECT Product_ID
FROM SuppliersXREFProducts WHERE SuppliersXREF.Supplier_ID = " &
[SuppliersXREFProducts.Supplier_ID]) AS ProductsSupplied
FROM Suppliers INNER JOIN (Reports INNER JOIN SuppliersXREFProducts ON
Reports.Report_ID = SuppliersXREFProducts.Report_ID) ON Suppliers.Supplier_ID
= SuppliersXREFProducts.Supplier_ID;

 

[Duane Hookom]

You have a table named "Reports"? This is a collection name in Access.
Did you create a module in Access and import or copy the Concatenate()
function?
What does any of this have to do with Word?

 

[JKarchner]

I did not create a module in Access. Would the Concatenate function already
be included with the program or do i have to locate a copy of it on the web.
I could not find any such file when i looked. With the reference to word, i
simply meant that i copied the code to a word document from the generic
sample and then re-wrote my expression underneath it and then copied it back
into excel. When i did this i received a different error. That was the
purpose of including that statement.

You have a table named "Reports"? This is a collection name in Access.
Did you create a module in Access and import or copy the Concatenate()
function?
What does any of this have to do with Word?

--
Duane Hookom
MS Access MVP

I am trying to concatenate a field in a list of records. I have used the
sample given be Duane Hookom. When i try to type the expression for a
concatenation i receive an error that says that concatenate is an
undefined
function, but when i copy and paste the code from Word, i receive a syntax
error on the first field in the concatenation section.
The code I am using:
SELECT Suppliers.Supplier, Reports.Report, Concatenate("SELECT Product_ID
FROM SuppliersXREFProducts WHERE SuppliersXREF.Supplier_ID = " &
[SuppliersXREFProducts.Supplier_ID]) AS ProductsSupplied
FROM Suppliers INNER JOIN (Reports INNER JOIN SuppliersXREFProducts ON
Reports.Report_ID = SuppliersXREFProducts.Report_ID) ON
Suppliers.Supplier_ID
= SuppliersXREFProducts.Supplier_ID;

 

[Duane Hookom]

The code is included in the sample mdb from the web. You explained the
"Word" reference but now you added a reference to "Excel".

--
Duane Hookom
MS Access MVP

I did not create a module in Access. Would the Concatenate function
already
be included with the program or do i have to locate a copy of it on the
web.
I could not find any such file when i looked. With the reference to word,
i
simply meant that i copied the code to a word document from the generic
sample and then re-wrote my expression underneath it and then copied it
back
into excel. When i did this i received a different error. That was the
purpose of including that statement.

You have a table named "Reports"? This is a collection name in Access.
Did you create a module in Access and import or copy the Concatenate()
function?
What does any of this have to do with Word?

--
Duane Hookom
MS Access MVP

I am trying to concatenate a field in a list of records. I have used
the
sample given be Duane Hookom. When i try to type the expression for a
concatenation i receive an error that says that concatenate is an
undefined
function, but when i copy and paste the code from Word, i receive a
syntax
error on the first field in the concatenation section.
The code I am using:
SELECT Suppliers.Supplier, Reports.Report, Concatenate("SELECT
Product_ID
FROM SuppliersXREFProducts WHERE SuppliersXREF.Supplier_ID = " &
[SuppliersXREFProducts.Supplier_ID]) AS ProductsSupplied
FROM Suppliers INNER JOIN (Reports INNER JOIN SuppliersXREFProducts ON
Reports.Report_ID = SuppliersXREFProducts.Report_ID) ON
Suppliers.Supplier_ID
= SuppliersXREFProducts.Supplier_ID;