Find Unmatched

[Guest]

Help!!! I think I am making this to hard.
I have a table from last week tblMemberOld
and I have the same table with updates from this week tblMemberNew.

I need help to find any new records that now have a service date and didn't
before. I have 2 situations:
1) Member was in tblmemberold and now has a service date and didn't before
2) I am running into problems when. I have a new member that was not in
tblmemberold and is now there and has a service date.

How can I create a unmatched qry that returns both situations? Fields are
Member Service date

 

[Guest]

Hi,
I don't believe that you can do this in 1 unmatched query. You can use
the unmatched query to handle #2.

To handle #1, create a select query with old and new table, joined on
member. Include one of the date fields in the query grid and the criteria
for the date would be that it is not equal to the other date.

 

[John Spencer]

SELECT N.*
FROM TblMemberNew As N Left Join tblMemberOld as O
On N.MemberID = O.MemberId
WHERE O.ServiceDate Is Null OR
N.ServiceDate <> O.ServiceDate OR