Ongoing Concatenate Problem

[Jen]

Looks like you're returning a string value....that's
probably why it's getting truncated. I'm not sure, but
maybe you could return a memo data type or maybe try not
specifying a data type.

Regards,
Jen

 

[Duane Hookom]

I think you should try create a table with 1 record ie: tblOneRec
SELECT fConcatenateRecords("productname","Table1",",") AS
Expr1 FROM tblOneRec;

BTW: please don't start a new thread. It is appropriate to simply reply to
the original thread as long as the question remains the same or similar.

 

[Keir]

Sorry, not sure what you mean. Do you mean manually create
a table and populate the record with a query? Or do you
mean use a query that dynamically creates a table?

Keir

PS. Sorry for starting another post. It's just my first
post didn't communicate my problem very well

 

[Jen]

Keir,

I think you misunderstood me. I'm looking at the
beginning of your function where you specify what data
type is returned.

Public Function fConcatenateRecords(strField As String,
strRecordset As String, strFieldSeparator As String) As
String

You're returning a string data type. What I'm saying is
to delete the type of data you're returning, in this case,
get rid of "As String" at the end of your function
declaration. See if it will return all the characters
this way.

Hope this was clearer.

Jen