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...
 

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

Union Query and Where Clause 1
Where clause is not working 1
Single WHERE and ORDER clause in UNION? 4
Aliases and the WHERE clause 5
SQL Query WHERE CLAUSE question 5
Simplifying a WHERE clause 3
Using a Function as a Where clause 2
Access Query result different when opened in automation 1

Back
Top