new records not showing on reports

  • Thread starter Thread starter Craig S.
  • Start date Start date
C

Craig S.

I built a complete Access database program with queries,
forms, reports... I then imported data into a database
from Works 4.5 and added new additional records to the
Access database. All records, new and imported show up on
all forms and tables. When I run reports, though, only
the imported records show up. The reports do, however,
show any changes that I made to the imported records but
the new records I added are not being picked up by my
queries, and thus not by their corresponding reports
either. Only the records that were imported are being
read by the queries. The forms work fine, the only (big)
problem is with the queries/reports.

Anyone familiar with the problem and how to fix it?
 
Okay, good. For some reason there is not an exact match on this string
value.

Is there any chance that there is a space in the field (e.g. " Complete")
that's preventing the match? Any language issues that could affect the
outcome, e.g. an accent over an "e"?

If you can't spot the difference, you could create a query into this table,
copy the "Complete" to clipboard from the datasheet, switch to design view,
and paste it back into the Critieria row. Check that the right records are
returned. Switch the query to an Update query (Update on Query menu). Type
"Complete" into the Update row (without the quotes). Run the query.
 
Back
Top