My query doesn't pick up records added to the table after a parti.

F

Fran the Confused

My query does not pick up any records added to the table after 10/9/07 but
there is no reason for this in the query itself. Also it does not pick up
records added before that date if any of the data in that record had been
amended since that date!
 
D

Dorian

Post the SQL of your query.
Are you running against a local table or linked tables?
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
K

KARL DEWEY

Are you using date criteria by chance such as "10/15/09"?
What is the datatype of your date field?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

In a query, show master records even if a child record doesn't exi 2
Append Query Issue 0
Append only new records to a table 2
Aggregate Query Question 1
Have both records from two queries/tables under one Query without related fields. 0
Why does MSAccess cut query after 2886000 records 1
Repeating records in Query 20
Only first few records visible in table after running append query 1

Top