Incomple Memo field displayed in query/report

[Guest]

I am trying to create a report from a query, I am trying to read a memo field
and only a portion of the text gets displayed. I verified the content of the
field in both the table and in the query and what is being displayed on my
report is exactly what I find in the query. Any idea why a field would have
partial info on the query result.

 

[Duane Hookom]

If your field is being truncated in your query, you should have provided
your SQL view to us. I expect you might have a phrase like "DISTINCT" or
"GROUP BY" in your query.

 

[Guest]

You are right I had assigned parameters on some of the fields and turned on
"Total" so every field without parameters were displaying "Group By". I
selected "Max" for my memo field and it seems to take care of the problem.
Thanks again...

 

[Taffski]

Funnily enough, changing the parameter to 'Max' returned an error message so
resorting to a simple process of elimination, i.e. testing each in turn, the
one that worked was selecting 'Last' in the Query then changing the Memo
field in the report to 'LastofFieldName'. I have no idea why it worked but
it did!!