Criteria - Returning more than specified

[twildt]

I have a query based on a table. The table has many fields. I am only interested in 3. I have pulled those 3 fields in the query.



query1
...ModuleName
...Status
...DateTime

When I specify criteria(="export") under the field [ModuleName] in my query I'm not getting records that only contain my criteria. How is this possible? I only want records that contain the word "export".

[June7]

That does sound odd.

Post the full SQL statement of the query.

If you want to provide db for analysis, follow instructions at bottom of my post.

[twildt]

I cannot append the database as it's all linked tables to an SQL server over ODBC so I'm thinking this won't help.

Here is my full SQL statement:
SELECT dbo_viewPagesScanned.[ModuleName], dbo_viewPagesScanned.[BatchStatus], dbo_viewPagesScanned.[SessionEndDateTime]
FROM dbo_viewPagesScanned
WHERE (((dbo_viewPagesScanned.[ModuleName])="export"));

[June7]

Can't see anything wrong with the SQL.

You could import records from the SQL db and test on the imported data. Are results same?

[twildt]

I just tried a Pass-Through query on that table. Using same SQL(fixing the underscore) it's giving me an ODBC--call failed error.

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Export'. (#207)

I linked the table and the "Design View" "Field Name" is saying "ModuleName". It should be correct... Unless I'm missing something... Could SQL send me altered column names? Or should I say the ODBC SQL connection be altered by Access?

[June7]

Sorry, not enough experience with SQL Server db to advise.

No idea why it thinks 'export' is a field.

Next test is to import data and see what you get.