Question re: module to concatenate fields

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

Guest

MS Access 2K, Windows XP
====================
Hi,

I have a question regarding the concatenate fields module on MVPS website-
http://www.mvps.org/access/modules/mdl0008.htm

I've used it before with no problem, but I'm trying to use it in a query to
concatenate the email addresses from a field, and it truncates the email
addresses at 255 characters. Why would it do that? From what I can tell from
looking at the module, the values are stored in a variant. Does it have a
limit of 255 characters?

I also tried redefining lovConcat as string, but that gave me the following
error: "#94 invalid use of null".

Will appreciate any help with this so that I can get all the email addresses
(with no limit on the final length) successfully.

Thanks.

-Amit
 
Duane Hookom said:
How about providing the SQL view of your query?
Click to expand...

Hi Duane,

Here is the SQL view:
SELECT qselCommitteeMembers.CommitteeID, qselCommitteeMembers.ProgramID,
fConcatFld("qselCommitteeMembers","CommitteeID","PersonEmail","Long",[CommitteeID]) AS EmailAddresses
FROM qselCommitteeMembers
GROUP BY qselCommitteeMembers.CommitteeID, qselCommitteeMembers.ProgramID,
fConcatFld("qselCommitteeMembers","CommitteeID","PersonEmail","Long",[CommitteeID]);

And the funny thing is that when I went to the design view, and deleted the
"group by" from under the Email column, it worked fine!!! :)

Somehow, having "Group By" in the Email column was curtailing the email
addresses to 255 characters. Would you know why? I think "Group By" appeared
under that column by default when I clicked the "Totals".

Thanks!!

-Amit
 
Group By will not display more than 255 characters. For a similar reason,
you can't sort on a memo field.

--
Duane Hookom
MS Access MVP
--

Amit said:
Duane Hookom said:
How about providing the SQL view of your query?
Click to expand...

Hi Duane,

Here is the SQL view:
SELECT qselCommitteeMembers.CommitteeID, qselCommitteeMembers.ProgramID,
fConcatFld("qselCommitteeMembers","CommitteeID","PersonEmail","Long",[CommitteeID])
AS EmailAddresses
FROM qselCommitteeMembers
GROUP BY qselCommitteeMembers.CommitteeID, qselCommitteeMembers.ProgramID,
fConcatFld("qselCommitteeMembers","CommitteeID","PersonEmail","Long",[CommitteeID]);

And the funny thing is that when I went to the design view, and deleted
the
"group by" from under the Email column, it worked fine!!! :)

Somehow, having "Group By" in the Email column was curtailing the email
addresses to 255 characters. Would you know why? I think "Group By"
appeared
under that column by default when I clicked the "Totals".

Thanks!!

-Amit
Click to expand...
 
Back
Top