Why won't all of my data in the query show up in the report?

P

peggymlb

The field is a "memo" field with the "can grow" function implemented. This
has just recently begun happening. All of the data is also not showing up in
an excel spreadsheet when I export it and analyze it with excel.
 
D

Duane Hookom

Does the full data show in the report's record source datasheet view? You
might have "Distinct" or "Group By" or similar in the report's record
source.
 
M

Marshall Barton

peggymlb said:
The field is a "memo" field with the "can grow" function implemented. This
has just recently begun happening. All of the data is also not showing up in
an excel spreadsheet when I export it and analyze it with excel.
Click to expand...


That's expected if you use a format (e.g. >) in the report's
text box or if the report's record source query uses an
operation that compares the memo field (e.g. Distinct,
Group By, Union)
 
Top