Why on Access is the report not picking-up all data from query?

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

Guest

I have completed the report from a query, the query contains information from
a table in memo format, and unfortunately the report is not showing all data
from the memo format.
 
My guess is that your field on your report is not big enough. Look at
the properties of the field in Design View. Change Can Grow to Yes and
then view your report. You should be able to see what is in your field
now.
 
Do you see "all data from the memo" when you view the datasheet of the
report's record source? If not, you probably have issues with phrases in
your SQL like DISTINCT or GROUP BY.
 
Back
Top