I need help with a database in Access -- here is a sample of a set of data:
PARCEL_NO LastOfSALE_DATE SALE_AMT OWNER NAME
0120295MF00000030 2/20/2009 100 WESLEY M G & AMY M
0120295MF00000030 1/19/1997 60000 WESLEY M G & AMY M
0120295MF00000030 6/19/1997 332600 WESLEY M G & AMY M...
Hi - need some help.
I need to run a query that would compare two fields in the same record and only display those records where the two addresses don't match.
Example:
Row Address1 Address2
1 123 Main St 549 Baker St
2 123 Main St 123 Main...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.