Query Truncating Memo Field

[Barb Miles]

I have a query that is querying from a table with a memo field. When the
query displays that memo field on a report, the field truncates the content
of that field even though the property "Can Grow" is set to yes. It custs
the number of characters displaying on the report to what appears to be
around 255 characters.

Any reason why?

 

[Duane Hookom]

Is this truncation occurring in your query or your report? Usually this is
from the query and is caused by phrases like "GROUP BY", "DISTINCT",...

 

[Barb Miles]

It is in the query and the report both.
--
Barb

Is this truncation occurring in your query or your report? Usually this is
from the query and is caused by phrases like "GROUP BY", "DISTINCT",...

 

[Barb Miles]

It is truncating in both the query and report.

 

[John Vinson]

It is truncating in both the query and report.

Well, actually in the query - the report is just showing what's in the
query.

Don't Group By or Sort the Memo field. Either will cause this
truncation. You may be able to use First instead of Group By if it's a
grouped query, provided the other fields you're using for grouping
uniquely select one record.

John W. Vinson[MVP]

 

[Barb Miles]

Changing the Group by to "First" gets a prompt that says to "Enter Parameter
Value." Any other ideas?

 

[Duane Hookom]

Here's an idea: post the sql view of your query.

 

[Barb Miles]

Here is the SQL code: The field name that is truncating is "gencom"

SELECT [T-Comments].appno, tblcreditapp.custname, [T-Comments].GenComDate,
First([T-Comments].gencom) AS FirstOfgencom, Count([T-Comments].GenComID) AS
CountOfGenComID, tblcreditapp.AnalystName
FROM [T-Comments] INNER JOIN tblcreditapp ON [T-Comments].appno =
tblcreditapp.appno
GROUP BY [T-Comments].appno, tblcreditapp.custname, [T-Comments].GenComDate,
tblcreditapp.AnalystName
HAVING (((tblcreditapp.custname)=[Forms]![f-run comment by customer
report]![custname]))
ORDER BY [T-Comments].GenComDate;

Got any other suggestions?

 

[John Vinson]

Changing the Group by to "First" gets a prompt that says to "Enter Parameter
Value." Any other ideas?

What parameter value is it asking for? Your Report/Form should have a
textbox bound to FirstOfGencom (not to Gencom):

SELECT
[T-Comments].appno,
tblcreditapp.custname,
[T-Comments].GenComDate,
First([T-Comments].gencom) AS FirstOfGencom,
Count([T-Comments].GenComID) AS CountOfGenComID,
tblcreditapp.AnalystName
FROM [T-Comments] INNER JOIN tblcreditapp
ON [T-Comments].appno = tblcreditapp.appno
GROUP BY
[T-Comments].appno,
tblcreditapp.custname,
[T-Comments].GenComDate,
tblcreditapp.AnalystName
WHERE (((tblcreditapp.custname) =
[Forms]![f-run comment by customer report]![custname]))
ORDER BY [T-Comments].GenComDate;

This doesn't look like it's going to be reliable though. If there are
multiple records from [T-Comments] for each combination of appno,
custname, analystname and GenComDate (i.e. two comments with the same
date value), you'll only see one of the comments!

John W. Vinson[MVP]

 

[Duane Hookom]

Shouldn't the WHERE come before the GROUP BY?

SELECT
[T-Comments].appno,
tblcreditapp.custname,
[T-Comments].GenComDate,
First([T-Comments].gencom) AS FirstOfGencom,
Count([T-Comments].GenComID) AS CountOfGenComID,
tblcreditapp.AnalystName
FROM [T-Comments] INNER JOIN tblcreditapp
ON [T-Comments].appno = tblcreditapp.appno
WHERE (((tblcreditapp.custname) =
[Forms]![f-run comment by customer report]![custname]))
GROUP BY
[T-Comments].appno,
tblcreditapp.custname,
[T-Comments].GenComDate,
tblcreditapp.AnalystName
ORDER BY [T-Comments].GenComDate;
--
Duane Hookom
MS Access MVP

Changing the Group by to "First" gets a prompt that says to "Enter
Parameter
Value." Any other ideas?

What parameter value is it asking for? Your Report/Form should have a
textbox bound to FirstOfGencom (not to Gencom):

SELECT
[T-Comments].appno,
tblcreditapp.custname,
[T-Comments].GenComDate,
First([T-Comments].gencom) AS FirstOfGencom,
Count([T-Comments].GenComID) AS CountOfGenComID,
tblcreditapp.AnalystName
FROM [T-Comments] INNER JOIN tblcreditapp
ON [T-Comments].appno = tblcreditapp.appno
GROUP BY
[T-Comments].appno,
tblcreditapp.custname,
[T-Comments].GenComDate,
tblcreditapp.AnalystName
WHERE (((tblcreditapp.custname) =
[Forms]![f-run comment by customer report]![custname]))
ORDER BY [T-Comments].GenComDate;

This doesn't look like it's going to be reliable though. If there are
multiple records from [T-Comments] for each combination of appno,
custname, analystname and GenComDate (i.e. two comments with the same
date value), you'll only see one of the comments!

John W. Vinson[MVP]