Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Microsoft Access forms/queries

Author  Topic 

itservices
Starting Member

1 Post

Posted - 2013-06-24 : 12:21:43
Question/Problem: I am using Microsoft Access forms/queries to filter on a SQL table as in the following:

SELECT dbo_Premier.CustName, dbo_Premier.Address, dbo_Premier.City, dbo_Premier.State, dbo_Premier.[Zip Code]
FROM dbo_Premier
WHERE (((dbo_Premier.Address) Like [Forms]![frmRosterSearch]![FindAdd] & "*"));

This filter returns incorrect results. The results seem to have no logical pattern that I can see what my error is. It appears the correct records are returned, but with lots of incorrect results also.

When I do the exact same filter on a local table in Microsoft Access with the same information in it, the results are returned correctly.

At first I thought that somehow maybe the information wasn’t being cleared out of the SQL table correctly because weekly I clear and repopulate this table, however, when I tried to build a brand new table in SQL from the local table, the filter was still incorrect.

Using:
SQLServer 2008 Standard
Access 2007
   

- Advertisement -