Where clause doesn't work

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
 
G

Guest

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
Single WHERE and ORDER clause in UNION? 4
SQL Query WHERE CLAUSE question 5
Simplifying a WHERE clause 3
how to determine logic of a linq where clause? 1
Cast or reg expression in where clause 2
Where clause in calculation 1
problem with WHERE clause when using Microsoft.Jet.OLEDB.4.0 5

Top