matching (or not matching) two address fields - same record

[techjules]

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 St


I need the query to show me only those records where Address1 and Address2 do not match.

Thx

Jules

 

[SkipVought]

hi,

Where Address1 <> Address2

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[dhookom]

Or to handle possible Null values:

Where Address1 & "" <> Address2 & ""

Duane
Hook'D on Access
MS Access MVP