Web Development



SQL queries to Access 2007 DB from Excel 2007

By roland.voyages ·
When executing the following SQL statements from within Excel 2007, the result set ignores the "where" clause.

If the same sql statements are executed from Access 2007, the result include 192 rows. From Excel 2007 pointed to the Access 2007 data source, the result is 241. The exact difference reflects the "where" clause.

Any suggestions?

Thank you for your assistance. _/).

SELECT [tbl:Staff_Locations].Login_ID, [tbl:Staff_Locations].Full_Name, [tbl:IT_NY_HR_Staff].CC
FROM [tbl:Staff_Locations] LEFT JOIN [tbl:IT_NY_HR_Staff] ON [tbl:Staff_Locations].Login_ID = [tbl:IT_NY_HR_Staff].User_ID
WHERE ((([tbl:Staff_Locations].Login_ID) Not Like 'tba*' And ([tbl:Staff_Locations].Login_ID) Not Like 'used*'))
ORDER BY [tbl:Staff_Locations].Full_Name;

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums