missing field data in several records in a report

P

Pia P

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?
 
J

Jeff Boyce

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?
 
P

Pia P

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.
 
J

Jeff Boyce

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?
 
P

Pia P

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
 
Top