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

  • Thread starter Thread starter Fran the Confused
  • Start date Start date
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!
 
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".
 
Are you using date criteria by chance such as "10/15/09"?
What is the datatype of your date field?
 
Back
Top