Posted - 06/24/2013 : 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]
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.
SQLServer 2008 Standard