Hi everyone, I have just signed up and in need of help. I have used Access for years but only now am I required to build reports.
I have a two lists of client details from 2 different sources. My goal is to compare these lists and only display records that match on 2 or more criteria.
My query so far is like this; (the 1 and 2 represent the different sources)
Surname1, Surname2, Name1, Name2, DOB1, DOB2, PostCode1, Postcode2
I am after a formula field that I can stick on the end which counts the number of matches. For example Surname=Surname=1, Surname=Surname & DOB=DOB =2
Currently surnames from both sources match as I have joined these together, so I am now just really trying to see if there are any other matches with DOB, Postcode etc.
I will then only show the records that are >=2
I would really appreciate any help.
Regards
Gavin