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