Text Field Character Limit in Reports

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

Guest

I am trying to include values from a concantonated field in a query in a
report. The field in the query displays exactly what I want, but it is
considerably longer than 255 characters. The text box in the report is
limiting the field length to 255 characters in the report.

Suggestions?
 
Thanks, Ken ... I had already set the can grow property to yes, and the
format property just doesn't seem to work on a text field. There are no drop
down choices and typing in memo returns m/em/o .. <g> ... I think that's not
going to get it. Other suggestions?
 
ok ... working on this. The concatonated field in the query *does* have a
255 char limit. I'll have to see if there's a way around it.
 
I have done both. I have one query that only concantonates, and another that
is a groupby. The fields in both queries are truncating the returned values
to 255 chars.
 
Post the SQL statements of the two queries, and identify the field size and
data type of each of the fields involved in the concatenations.
 
Concantonate function was written by Duane Hookum and modified, of course, to
work w/my db.

QryAttendees

SELECT TblAGAtt.AGMtgID, ([Firstname] & " " & [Lastname] & ", " &
[CompanyName]) AS AttName, Concatenate("SELECT AttName FROM qryattendees
WHERE AGMtgID=" & [AGMtgID],"; ") AS List
FROM TblAGAtt LEFT JOIN TblContacts ON
TblAGAtt.AGAttID=TblContacts.CustomerID;

QryAttendeesGroupBy

SELECT QryAttendees.AGMtgID, QryAttendees.List
FROM QryAttendees
GROUP BY QryAttendees.AGMtgID, QryAttendees.List;

[FirstName], [LastName], and [CompanyName] are text fields, 255 length. The
only field that I report is
  • , and that's the one that's truncating.

    btw ... THANKS!!!
 
You have the List field in the GROUP BY clause. That will cause that field's
contents to be truncated to 255 characters. I suggest that you modify the
QryAttendeesGroupBy query to this; I think this will get around that
problem:

SELECT QryAttendees.AGMtgID, Left([QryAttendees].
  • , 255) AS GrBy,
    First(QryAttendees.List) AS TheList
    FROM QryAttendees
    GROUP BY QryAttendees.AGMtgID, Left([QryAttendees].
    • , 255);


      --

      Ken Snell
      <MS ACCESS MVP>


      Kate said:
      Concantonate function was written by Duane Hookum and modified, of course,
      to
      work w/my db.

      QryAttendees

      SELECT TblAGAtt.AGMtgID, ([Firstname] & " " & [Lastname] & ", " &
      [CompanyName]) AS AttName, Concatenate("SELECT AttName FROM qryattendees
      WHERE AGMtgID=" & [AGMtgID],"; ") AS List
      FROM TblAGAtt LEFT JOIN TblContacts ON
      TblAGAtt.AGAttID=TblContacts.CustomerID;

      QryAttendeesGroupBy

      SELECT QryAttendees.AGMtgID, QryAttendees.List
      FROM QryAttendees
      GROUP BY QryAttendees.AGMtgID, QryAttendees.List;

      [FirstName], [LastName], and [CompanyName] are text fields, 255 length.
      The
      only field that I report is
      • , and that's the one that's truncating.

        btw ... THANKS!!!

        Ken Snell said:
        Post the SQL statements of the two queries, and identify the field size
        and
        data type of each of the fields involved in the concatenations.
        Click to expand...
      Click to expand...
 
I actually do not *need* the groupby, but the
  • field in QryAttendees is
    already truncated in that query.

    However .. I did try this, and it still truncates @ 255 characters. Did I
    miss something?

    Ken Snell said:
    You have the List field in the GROUP BY clause. That will cause that field's
    contents to be truncated to 255 characters. I suggest that you modify the
    QryAttendeesGroupBy query to this; I think this will get around that
    problem:

    SELECT QryAttendees.AGMtgID, Left([QryAttendees].
    • , 255) AS GrBy,
      First(QryAttendees.List) AS TheList
      FROM QryAttendees
      GROUP BY QryAttendees.AGMtgID, Left([QryAttendees].
      • , 255);


        --

        Ken Snell
        <MS ACCESS MVP>


        Kate said:
        Concantonate function was written by Duane Hookum and modified, of course,
        to
        work w/my db.

        QryAttendees

        SELECT TblAGAtt.AGMtgID, ([Firstname] & " " & [Lastname] & ", " &
        [CompanyName]) AS AttName, Concatenate("SELECT AttName FROM qryattendees
        WHERE AGMtgID=" & [AGMtgID],"; ") AS List
        FROM TblAGAtt LEFT JOIN TblContacts ON
        TblAGAtt.AGAttID=TblContacts.CustomerID;

        QryAttendeesGroupBy

        SELECT QryAttendees.AGMtgID, QryAttendees.List
        FROM QryAttendees
        GROUP BY QryAttendees.AGMtgID, QryAttendees.List;

        [FirstName], [LastName], and [CompanyName] are text fields, 255 length.
        The
        only field that I report is
        • , and that's the one that's truncating.

          btw ... THANKS!!!

          Ken Snell said:
          Post the SQL statements of the two queries, and identify the field size
          and
          data type of each of the fields involved in the concatenations.


          --

          Ken Snell
          <MS ACCESS MVP>

          I have done both. I have one query that only concantonates, and another
          that
          is a groupby. The fields in both queries are truncating the returned
          values
          to 255 chars.

          :

          I am trying to include values from a concantonated field in a query in
          a
          report. The field in the query displays exactly what I want, but it
          is
          considerably longer than 255 characters. The text box in the report
          is
          limiting the field length to 255 characters in the report.

          Suggestions?
          Click to expand...
        Click to expand...
    Click to expand...
 
I don't see anything in the QryAttendees that should cause the List field to
be truncated in that query. Just to be sure I'm understanding you, you're
saying that, if you run the QryAttendees query manually, the string in the
List field is truncated at 255 characters?

I've reviewed your QryAttendees query's SQL statement, and it appears that
your code is recursively calling that same query in the CONCATENATE
function. Is that indeed what you want? I've got to think that this is going
to cause problems for you.

Perhaps you should create a separate query for the Concatenate function to
use in its SQL statement that you send to it.
--

Ken Snell
<MS ACCESS MVP>



Kate said:
I actually do not *need* the groupby, but the
  • field in QryAttendees
    is
    already truncated in that query.

    However .. I did try this, and it still truncates @ 255 characters. Did I
    miss something?

    Ken Snell said:
    You have the List field in the GROUP BY clause. That will cause that
    field's
    contents to be truncated to 255 characters. I suggest that you modify the
    QryAttendeesGroupBy query to this; I think this will get around that
    problem:

    SELECT QryAttendees.AGMtgID, Left([QryAttendees].
    • , 255) AS GrBy,
      First(QryAttendees.List) AS TheList
      FROM QryAttendees
      GROUP BY QryAttendees.AGMtgID, Left([QryAttendees].
      • , 255);


        --

        Ken Snell
        <MS ACCESS MVP>


        Kate said:
        Concantonate function was written by Duane Hookum and modified, of
        course,
        to
        work w/my db.

        QryAttendees

        SELECT TblAGAtt.AGMtgID, ([Firstname] & " " & [Lastname] & ", " &
        [CompanyName]) AS AttName, Concatenate("SELECT AttName FROM
        qryattendees
        WHERE AGMtgID=" & [AGMtgID],"; ") AS List
        FROM TblAGAtt LEFT JOIN TblContacts ON
        TblAGAtt.AGAttID=TblContacts.CustomerID;

        QryAttendeesGroupBy

        SELECT QryAttendees.AGMtgID, QryAttendees.List
        FROM QryAttendees
        GROUP BY QryAttendees.AGMtgID, QryAttendees.List;

        [FirstName], [LastName], and [CompanyName] are text fields, 255 length.
        The
        only field that I report is
        • , and that's the one that's
          truncating.

          btw ... THANKS!!!

          :

          Post the SQL statements of the two queries, and identify the field
          size
          and
          data type of each of the fields involved in the concatenations.


          --

          Ken Snell
          <MS ACCESS MVP>

          I have done both. I have one query that only concantonates, and
          another
          that
          is a groupby. The fields in both queries are truncating the
          returned
          values
          to 255 chars.

          :

          I am trying to include values from a concantonated field in a query
          in
          a
          report. The field in the query displays exactly what I want, but
          it
          is
          considerably longer than 255 characters. The text box in the
          report
          is
          limiting the field length to 255 characters in the report.

          Suggestions?
        Click to expand...
    Click to expand...
Click to expand...
 
What I have discovered is that in QryAttendees

SELECT DISTINCT TblAGAtt.AGMtgID, ([Firstname] & " " & [Lastname] & ", " &
[CompanyName]) AS AttName, Concatenate("SELECT AttName FROM QryAttendees
WHERE AGMtgID=" & [AGMtgID],"; ") AS List
FROM TblAGAtt INNER JOIN TblContacts ON TblAGAtt.AGAttID =
TblContacts.CustomerID;

What triggers the truncation is setting the property to unique records. It
may be somehow involved w/ the recursive call, as you pointed out. Haven't
figured it out yet, but I thought I'd update you on where this is.

Thanks again for your help. I'll get back when I have a solution, or if you
get it, please let me know. I won't be able to turn it loose until if find a
resolution ...

Ken Snell said:
I don't see anything in the QryAttendees that should cause the List field to
be truncated in that query. Just to be sure I'm understanding you, you're
saying that, if you run the QryAttendees query manually, the string in the
List field is truncated at 255 characters?

I've reviewed your QryAttendees query's SQL statement, and it appears that
your code is recursively calling that same query in the CONCATENATE
function. Is that indeed what you want? I've got to think that this is going
to cause problems for you.

Perhaps you should create a separate query for the Concatenate function to
use in its SQL statement that you send to it.
--

Ken Snell
<MS ACCESS MVP>



Kate said:
I actually do not *need* the groupby, but the
  • field in QryAttendees
    is
    already truncated in that query.

    However .. I did try this, and it still truncates @ 255 characters. Did I
    miss something?

    Ken Snell said:
    You have the List field in the GROUP BY clause. That will cause that
    field's
    contents to be truncated to 255 characters. I suggest that you modify the
    QryAttendeesGroupBy query to this; I think this will get around that
    problem:

    SELECT QryAttendees.AGMtgID, Left([QryAttendees].
    • , 255) AS GrBy,
      First(QryAttendees.List) AS TheList
      FROM QryAttendees
      GROUP BY QryAttendees.AGMtgID, Left([QryAttendees].
      • , 255);


        --

        Ken Snell
        <MS ACCESS MVP>


        Concantonate function was written by Duane Hookum and modified, of
        course,
        to
        work w/my db.

        QryAttendees

        SELECT TblAGAtt.AGMtgID, ([Firstname] & " " & [Lastname] & ", " &
        [CompanyName]) AS AttName, Concatenate("SELECT AttName FROM
        qryattendees
        WHERE AGMtgID=" & [AGMtgID],"; ") AS List
        FROM TblAGAtt LEFT JOIN TblContacts ON
        TblAGAtt.AGAttID=TblContacts.CustomerID;

        QryAttendeesGroupBy

        SELECT QryAttendees.AGMtgID, QryAttendees.List
        FROM QryAttendees
        GROUP BY QryAttendees.AGMtgID, QryAttendees.List;

        [FirstName], [LastName], and [CompanyName] are text fields, 255 length.
        The
        only field that I report is
        • , and that's the one that's
          truncating.

          btw ... THANKS!!!

          :

          Post the SQL statements of the two queries, and identify the field
          size
          and
          data type of each of the fields involved in the concatenations.


          --

          Ken Snell
          <MS ACCESS MVP>

          I have done both. I have one query that only concantonates, and
          another
          that
          is a groupby. The fields in both queries are truncating the
          returned
          values
          to 255 chars.

          :

          I am trying to include values from a concantonated field in a query
          in
          a
          report. The field in the query displays exactly what I want, but
          it
          is
          considerably longer than 255 characters. The text box in the
          report
          is
          limiting the field length to 255 characters in the report.

          Suggestions?
    Click to expand...
Click to expand...
Click to expand...
 
Using DISTINCT (unique records) likely is the cause of the truncation.

Are you just wanting to get a list of attendees for each AGMtgID value? If
yes, I suggest that you create one additional query (name it QrySingleAtts):

SELECT TblAGAtt.AGMtgID, ([Firstname] & " " & [Lastname] & ", " &
[CompanyName]) AS AttName
FROM TblAGAtt INNER JOIN TblContacts ON TblAGAtt.AGAttID =
TblContacts.CustomerID;


Then change your QryAttendees query to this (replace MeetingIDTable with the
real name of the table that contains the list of meeting ID values):

SELECT AGMtgID, Concatenate("SELECT AttName FROM QrySingleAtts
AS Q WHERE Q.AGMtgID=" & [AGMtgID],"; ") AS List
FROM MeetingIDTable;


Then use the QryAttendees query (as modified by me above) to get the final
concatenated listing. You shouldn't need your QryAttendeesGroupBy query at
all.
--

Ken Snell
<MS ACCESS MVP>




Kate said:
What I have discovered is that in QryAttendees

SELECT DISTINCT TblAGAtt.AGMtgID, ([Firstname] & " " & [Lastname] & ", " &
[CompanyName]) AS AttName, Concatenate("SELECT AttName FROM QryAttendees
WHERE AGMtgID=" & [AGMtgID],"; ") AS List
FROM TblAGAtt INNER JOIN TblContacts ON TblAGAtt.AGAttID =
TblContacts.CustomerID;

What triggers the truncation is setting the property to unique records.
It
may be somehow involved w/ the recursive call, as you pointed out.
Haven't
figured it out yet, but I thought I'd update you on where this is.

Thanks again for your help. I'll get back when I have a solution, or if
you
get it, please let me know. I won't be able to turn it loose until if
find a
resolution ...

Ken Snell said:
I don't see anything in the QryAttendees that should cause the List field
to
be truncated in that query. Just to be sure I'm understanding you, you're
saying that, if you run the QryAttendees query manually, the string in
the
List field is truncated at 255 characters?

I've reviewed your QryAttendees query's SQL statement, and it appears
that
your code is recursively calling that same query in the CONCATENATE
function. Is that indeed what you want? I've got to think that this is
going
to cause problems for you.

Perhaps you should create a separate query for the Concatenate function
to
use in its SQL statement that you send to it.
--

Ken Snell
<MS ACCESS MVP>



Kate said:
I actually do not *need* the groupby, but the
  • field in
    QryAttendees
    is
    already truncated in that query.

    However .. I did try this, and it still truncates @ 255 characters.
    Did I
    miss something?

    :

    You have the List field in the GROUP BY clause. That will cause that
    field's
    contents to be truncated to 255 characters. I suggest that you modify
    the
    QryAttendeesGroupBy query to this; I think this will get around that
    problem:

    SELECT QryAttendees.AGMtgID, Left([QryAttendees].
    • , 255) AS GrBy,
      First(QryAttendees.List) AS TheList
      FROM QryAttendees
      GROUP BY QryAttendees.AGMtgID, Left([QryAttendees].
      • , 255);


        --

        Ken Snell
        <MS ACCESS MVP>


        Concantonate function was written by Duane Hookum and modified, of
        course,
        to
        work w/my db.

        QryAttendees

        SELECT TblAGAtt.AGMtgID, ([Firstname] & " " & [Lastname] & ", " &
        [CompanyName]) AS AttName, Concatenate("SELECT AttName FROM
        qryattendees
        WHERE AGMtgID=" & [AGMtgID],"; ") AS List
        FROM TblAGAtt LEFT JOIN TblContacts ON
        TblAGAtt.AGAttID=TblContacts.CustomerID;

        QryAttendeesGroupBy

        SELECT QryAttendees.AGMtgID, QryAttendees.List
        FROM QryAttendees
        GROUP BY QryAttendees.AGMtgID, QryAttendees.List;

        [FirstName], [LastName], and [CompanyName] are text fields, 255
        length.
        The
        only field that I report is
        • , and that's the one that's
          truncating.

          btw ... THANKS!!!

          :

          Post the SQL statements of the two queries, and identify the field
          size
          and
          data type of each of the fields involved in the concatenations.


          --

          Ken Snell
          <MS ACCESS MVP>

          I have done both. I have one query that only concantonates, and
          another
          that
          is a groupby. The fields in both queries are truncating the
          returned
          values
          to 255 chars.

          :

          I am trying to include values from a concantonated field in a
          query
          in
          a
          report. The field in the query displays exactly what I want,
          but
          it
          is
          considerably longer than 255 characters. The text box in the
          report
          is
          limiting the field length to 255 characters in the report.

          Suggestions?
Click to expand...
Click to expand...
Click to expand...
 
YES!!!! OK .. it took a bit more than that. I also had to recreate the
subform where the attendees appear. They key to making it work was finding
any source using DISTINCT. It was, indeed, the reason the concantonated
field was truncating.

Thank you, Ken, for your patience and persistence.

Ken Snell said:
Using DISTINCT (unique records) likely is the cause of the truncation.

Are you just wanting to get a list of attendees for each AGMtgID value? If
yes, I suggest that you create one additional query (name it QrySingleAtts):

SELECT TblAGAtt.AGMtgID, ([Firstname] & " " & [Lastname] & ", " &
[CompanyName]) AS AttName
FROM TblAGAtt INNER JOIN TblContacts ON TblAGAtt.AGAttID =
TblContacts.CustomerID;


Then change your QryAttendees query to this (replace MeetingIDTable with the
real name of the table that contains the list of meeting ID values):

SELECT AGMtgID, Concatenate("SELECT AttName FROM QrySingleAtts
AS Q WHERE Q.AGMtgID=" & [AGMtgID],"; ") AS List
FROM MeetingIDTable;


Then use the QryAttendees query (as modified by me above) to get the final
concatenated listing. You shouldn't need your QryAttendeesGroupBy query at
all.
--

Ken Snell
<MS ACCESS MVP>




Kate said:
What I have discovered is that in QryAttendees

SELECT DISTINCT TblAGAtt.AGMtgID, ([Firstname] & " " & [Lastname] & ", " &
[CompanyName]) AS AttName, Concatenate("SELECT AttName FROM QryAttendees
WHERE AGMtgID=" & [AGMtgID],"; ") AS List
FROM TblAGAtt INNER JOIN TblContacts ON TblAGAtt.AGAttID =
TblContacts.CustomerID;

What triggers the truncation is setting the property to unique records.
It
may be somehow involved w/ the recursive call, as you pointed out.
Haven't
figured it out yet, but I thought I'd update you on where this is.

Thanks again for your help. I'll get back when I have a solution, or if
you
get it, please let me know. I won't be able to turn it loose until if
find a
resolution ...

Ken Snell said:
I don't see anything in the QryAttendees that should cause the List field
to
be truncated in that query. Just to be sure I'm understanding you, you're
saying that, if you run the QryAttendees query manually, the string in
the
List field is truncated at 255 characters?

I've reviewed your QryAttendees query's SQL statement, and it appears
that
your code is recursively calling that same query in the CONCATENATE
function. Is that indeed what you want? I've got to think that this is
going
to cause problems for you.

Perhaps you should create a separate query for the Concatenate function
to
use in its SQL statement that you send to it.
--

Ken Snell
<MS ACCESS MVP>



I actually do not *need* the groupby, but the
  • field in
    QryAttendees
    is
    already truncated in that query.

    However .. I did try this, and it still truncates @ 255 characters.
    Did I
    miss something?

    :

    You have the List field in the GROUP BY clause. That will cause that
    field's
    contents to be truncated to 255 characters. I suggest that you modify
    the
    QryAttendeesGroupBy query to this; I think this will get around that
    problem:

    SELECT QryAttendees.AGMtgID, Left([QryAttendees].
    • , 255) AS GrBy,
      First(QryAttendees.List) AS TheList
      FROM QryAttendees
      GROUP BY QryAttendees.AGMtgID, Left([QryAttendees].
      • , 255);


        --

        Ken Snell
        <MS ACCESS MVP>


        Concantonate function was written by Duane Hookum and modified, of
        course,
        to
        work w/my db.

        QryAttendees

        SELECT TblAGAtt.AGMtgID, ([Firstname] & " " & [Lastname] & ", " &
        [CompanyName]) AS AttName, Concatenate("SELECT AttName FROM
        qryattendees
        WHERE AGMtgID=" & [AGMtgID],"; ") AS List
        FROM TblAGAtt LEFT JOIN TblContacts ON
        TblAGAtt.AGAttID=TblContacts.CustomerID;

        QryAttendeesGroupBy

        SELECT QryAttendees.AGMtgID, QryAttendees.List
        FROM QryAttendees
        GROUP BY QryAttendees.AGMtgID, QryAttendees.List;

        [FirstName], [LastName], and [CompanyName] are text fields, 255
        length.
        The
        only field that I report is
        • , and that's the one that's
          truncating.

          btw ... THANKS!!!

          :

          Post the SQL statements of the two queries, and identify the field
          size
          and
          data type of each of the fields involved in the concatenations.


          --

          Ken Snell
          <MS ACCESS MVP>

          I have done both. I have one query that only concantonates, and
          another
          that
          is a groupby. The fields in both queries are truncating the
          returned
          values
          to 255 chars.

          :

          I am trying to include values from a concantonated field in a
          query
          in
          a
          report. The field in the query displays exactly what I want,
          but
          it
          is
          considerably longer than 255 characters. The text box in the
          report
          is
          limiting the field length to 255 characters in the report.

          Suggestions?
Click to expand...
Click to expand...
Click to expand...
 
You're welcome.

--

Ken Snell
<MS ACCESS MVP>

Kate said:
YES!!!! OK .. it took a bit more than that. I also had to recreate the
subform where the attendees appear. They key to making it work was
finding
any source using DISTINCT. It was, indeed, the reason the concantonated
field was truncating.

Thank you, Ken, for your patience and persistence.

Ken Snell said:
Using DISTINCT (unique records) likely is the cause of the truncation.

Are you just wanting to get a list of attendees for each AGMtgID value?
If
yes, I suggest that you create one additional query (name it
QrySingleAtts):

SELECT TblAGAtt.AGMtgID, ([Firstname] & " " & [Lastname] & ", " &
[CompanyName]) AS AttName
FROM TblAGAtt INNER JOIN TblContacts ON TblAGAtt.AGAttID =
TblContacts.CustomerID;


Then change your QryAttendees query to this (replace MeetingIDTable with
the
real name of the table that contains the list of meeting ID values):

SELECT AGMtgID, Concatenate("SELECT AttName FROM QrySingleAtts
AS Q WHERE Q.AGMtgID=" & [AGMtgID],"; ") AS List
FROM MeetingIDTable;


Then use the QryAttendees query (as modified by me above) to get the
final
concatenated listing. You shouldn't need your QryAttendeesGroupBy query
at
all.
--

Ken Snell
<MS ACCESS MVP>




Kate said:
What I have discovered is that in QryAttendees

SELECT DISTINCT TblAGAtt.AGMtgID, ([Firstname] & " " & [Lastname] & ",
" &
[CompanyName]) AS AttName, Concatenate("SELECT AttName FROM
QryAttendees
WHERE AGMtgID=" & [AGMtgID],"; ") AS List
FROM TblAGAtt INNER JOIN TblContacts ON TblAGAtt.AGAttID =
TblContacts.CustomerID;

What triggers the truncation is setting the property to unique records.
It
may be somehow involved w/ the recursive call, as you pointed out.
Haven't
figured it out yet, but I thought I'd update you on where this is.

Thanks again for your help. I'll get back when I have a solution, or
if
you
get it, please let me know. I won't be able to turn it loose until if
find a
resolution ...

:

I don't see anything in the QryAttendees that should cause the List
field
to
be truncated in that query. Just to be sure I'm understanding you,
you're
saying that, if you run the QryAttendees query manually, the string in
the
List field is truncated at 255 characters?

I've reviewed your QryAttendees query's SQL statement, and it appears
that
your code is recursively calling that same query in the CONCATENATE
function. Is that indeed what you want? I've got to think that this is
going
to cause problems for you.

Perhaps you should create a separate query for the Concatenate
function
to
use in its SQL statement that you send to it.
--

Ken Snell
<MS ACCESS MVP>



I actually do not *need* the groupby, but the
  • field in
    QryAttendees
    is
    already truncated in that query.

    However .. I did try this, and it still truncates @ 255 characters.
    Did I
    miss something?

    :

    You have the List field in the GROUP BY clause. That will cause
    that
    field's
    contents to be truncated to 255 characters. I suggest that you
    modify
    the
    QryAttendeesGroupBy query to this; I think this will get around
    that
    problem:

    SELECT QryAttendees.AGMtgID, Left([QryAttendees].
    • , 255) AS
      GrBy,
      First(QryAttendees.List) AS TheList
      FROM QryAttendees
      GROUP BY QryAttendees.AGMtgID, Left([QryAttendees].
      • , 255);


        --

        Ken Snell
        <MS ACCESS MVP>


        Concantonate function was written by Duane Hookum and modified,
        of
        course,
        to
        work w/my db.

        QryAttendees

        SELECT TblAGAtt.AGMtgID, ([Firstname] & " " & [Lastname] & ", " &
        [CompanyName]) AS AttName, Concatenate("SELECT AttName FROM
        qryattendees
        WHERE AGMtgID=" & [AGMtgID],"; ") AS List
        FROM TblAGAtt LEFT JOIN TblContacts ON
        TblAGAtt.AGAttID=TblContacts.CustomerID;

        QryAttendeesGroupBy

        SELECT QryAttendees.AGMtgID, QryAttendees.List
        FROM QryAttendees
        GROUP BY QryAttendees.AGMtgID, QryAttendees.List;

        [FirstName], [LastName], and [CompanyName] are text fields, 255
        length.
        The
        only field that I report is
        • , and that's the one that's
          truncating.

          btw ... THANKS!!!

          :

          Post the SQL statements of the two queries, and identify the
          field
          size
          and
          data type of each of the fields involved in the concatenations.


          --

          Ken Snell
          <MS ACCESS MVP>

          I have done both. I have one query that only concantonates,
          and
          another
          that
          is a groupby. The fields in both queries are truncating the
          returned
          values
          to 255 chars.

          :

          I am trying to include values from a concantonated field in a
          query
          in
          a
          report. The field in the query displays exactly what I want,
          but
          it
          is
          considerably longer than 255 characters. The text box in the
          report
          is
          limiting the field length to 255 characters in the report.

          Suggestions?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top