Concatenate Problems

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JKarchner - 24 Jul 2006 15:21 GMT

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;

Reply to this Message

Duane Hookom - 24 Jul 2006 15:36 GMT

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?

Signature

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
[quoted text clipped - 10 lines]
> Suppliers.Supplier_ID
> = SuppliersXREFProducts.Supplier_ID;

Reply to this Message

JKarchner - 24 Jul 2006 16:16 GMT

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()
[quoted text clipped - 15 lines]
> > Suppliers.Supplier_ID
> > = SuppliersXREFProducts.Supplier_ID;

Reply to this Message

Duane Hookom - 24 Jul 2006 18:24 GMT

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

Signature

Duane Hookom
MS Access MVP

>I did not create a module in Access. Would the Concatenate function
>already
[quoted text clipped - 30 lines]
>> > Suppliers.Supplier_ID
>> > = SuppliersXREFProducts.Supplier_ID;

Reply to this Message