Incomple Memo field displayed in query/report

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

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.
 
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.
 
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...
 
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!!
 
Back
Top