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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Size of memo contro on report 2
text box in report is truncating memo field at 255 characters 2
Memo field truncating in report 3
Report Can Grow not aligned horizontally 2
Memo field is truncating in group heading of an Access 2007 report 3
Exporting to word misses off data 4
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1

Back
Top