SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Microsoft Access forms/queries
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

itservices
Starting Member

USA
1 Posts

Posted - 06/24/2013 :  12:21:43  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000