Where clause doesn't work

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is going to sound like I'm making this up but I have a situation like this..

The app is a Access 97 mdb with linked tables to SQL Server. When I try to write a simple query like "Select * From aTable where [Date] > #01/01/2004#", the result set shows records that seem to ignore the where clause. Now it gets interesting, when I export the results as a Excel spreadsheet, the resultset is correct which means the where clause is recognized. What the @#$%?!? Has anyone seen this behavior before? If so, what is the cause and cure

Thanks in advance
Steve
 
Fixed! Just had to refresh the linked tables and it works fine now. Kinda scary how it got out of whack in the first place...
 
Back
Top