new records not showing on reports

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

 

[Allen Browne]

The problem is most likely in the criteria or joins of the query.
See:
The Query Lost My Records!
at:
http://allenbrowne.com/casu-02.html

 

[Allen Browne]

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.