Query Error (Picture)
Windows 7 64bit 
Access 2010 64bit
Please see the image below that clearly illustrates the problem.
I wrote a simple query in my database that returns addresses where the fields "situs_address" and "Owner_address" are not the same. This works fine; however, when I add an additional field to the query it stops functioning correctly.
I add the city field and set it to 024, a specific city in texas, and now the query returns records where situs_address and owner_address are both equal and not equal to each other. It should only return records where the two fields are not equal to each other within city 024. Not sure why adding the city field seems to make the query stop behaving correctly.
Reply With Quote
