Custom Query Help

[samanthaM]

Im attempting to write a query that runs through the whole database and checks the "Owner_Address" and "Situs_Address" fields. When the Owner Address and Situs Address contain the same information, no record is returned by the query, when there is a mismatch a record should be returned.

If Owner_Address & Situs_Address match, then nothing should be returned by the query
For example:


Owner Address: 123 Main Street Situs Address:123 Main Street
This would not return a record because Owner address and Situs Address are the same.

The query should only return mismatches between Owner Address and Situs Address.
For Example:
Owner Address: PO Box 341 Situs Address: 345 Green Hill
This would return a record because there is a mismatch between owner address & Situs address

[alansidman]

Are these two fields in the same table or in different tables.

[samanthaM]

These fields are in the same table.

[orange]

Select Owner_address
, Situs_Address
FROM
YOUR_TABLE_NAME
WHERE
[Owner_address] <>Situs_Address;

(untested)

[samanthaM]

Select Owner_address
, Situs_Address
FROM
YOUR_TABLE_NAME
WHERE
[Owner_address] <>Situs_Address;

(untested)

Pardon my ignorance Orange, but where does this query information get entered? I don't see the options such as "FROM" or "WHERE" in query design view.

Thank you.

[orange]

Go to query wizard--> SQL View -> and paste it in. Then Run or ! (the big exclamation point)

[orange]

If you are just learning Access and you have Acc2010, there is a series of free videos that might be helpful to you.

First is http://www.youtube.com/watch?v=pHiOX...eature=related
You can get to the others from this one.

[samanthaM]

@Orange, thanks it works great! Also thanks for the videos, thanks again for helping me.

[orange]

Glad to help.