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

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

Guest

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