Acc 2007 nedd help with inner join and not equal to

[DougP]

I have two tables: I want to compate emails in both tables based on last name.

I want to find everyone whose email is differnt from what we have on file to update it. the table we have on file is called [Data from pdf Latest] teh moste recent email is in the [WordCalendarDirectoryDump] table.
Here is my query , right now it appears to be ignoring the "not equal to" and returning eveything.

SELECT [Data from pdf Latest].Lastname, WordCalendarDirectoryDump.Parents, [Data from pdf Latest].[EMail Address], WordCalendarDirectoryDump.email
FROM WordCalendarDirectoryDump INNER JOIN [Data from pdf Latest] ON WordCalendarDirectoryDump.Lastname = [Data from pdf Latest].Lastname
WHERE ((([Data from pdf Latest].[EMail Address])<>[WordCalendarDirectoryDump].[email]));

TIA

DougP

 

[lameid]

Assuming you have three Smith's, John, Jane and Mark; I would expect them each to have different e-mail addresses. Since they share a last name then John's e-mail address is not equal to Jane's and Mark's e-mail address. So you get both of those even if they do match one to one.

I am just guessing that is your issue since you are joining on last name. I do not see first name.

 

[DougP]

these are families at the church I just need last name and email.
Compatre last names and see if email is differnt is all I need.

DougP

 

[lameid]

Your query seems to be describing the same thing you are saying...

You might try looking for repeated last names in both list or other data issues.

 

[JoeAtWork]

So you are saying there are no two people with the same Last Name in either [Data from pdf Latest] or [WordCalendarDirectoryDump]? I agree with lameid that this is the most likely cause of your trouble.

Otherwise, I suspect your [EMail Address] and fields look the same but are actually different, for example maybe one has an extra space at the beginning or end.