missing field data in several records in a report

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

Guest

I'd appreciate any suggestions on solving this problem. When displaying a
report several of the records are missing data in one of the fields. Other
records display the data o/k and the field displays correctly in the table,
form and query. I have deleted the data and re-entered it, have compacted the
database, redone the query and the report, all to no avail. Any suggestions?
 
Pia

Is your report based directly on a table, or on a query? If a query, what
does that query return when run?

Is there a chance that any of the 'missing' data is from a field that might
have blanks and other characters (i.e., a memo field)?

--
Good luck

Jeff Boyce
<Access MVP>

Pia P said:
I'd appreciate any suggestions on solving this problem. When displaying a
report several of the records are missing data in one of the fields. Other
records display the data o/k and the field displays correctly in the table,
form and query. I have deleted the data and re-entered it, have compacted the
database, redone the query and the report, all to no avail. Any
Click to expand...
suggestions?
 
Thanks for taking the trouble to reply Jeff. The report is based on a query
and the query returns all the required fields when run, so I don't think this
is the problem (but I could be wrong, still being a novice Access user).
Interestingly, when I export the query result to MS word, all the values are
displayed correctly and no data is missing.
 
Pia

Oooh! That makes it a real puzzle!

Is there something different about the properties of the report controls
that DO display their data, when compared with those that DON'T?
 
Hi Jeff

Not from what I can see. It looks like it will continue to remain a bit of a
puzzle. I have exported the data into Word and it displays fine, so maybe
will continue to do that rather than use this particular report - a bit of a
nuisance but at least all the data displays. Many thanks for your advice and
input.

Pia P
 
Back
Top