Hi All,
I'm looking for a way to build a report that will find which City names I haven't matched for each record in a separate table.
I have 3 tables and 1 query involved to solve this problem, one containing my clients job details [Client Data], one containing the other cities jobs [Competitor Data], one with the matches between the client jobs and competitor cities [Matched Jobs], and one (query) with a unique list of competitor Cities [Unique List of Competitor Cities].
So, how do I build a report to tell me, by record in Client Data, which cities I do not currently have a match for from [Matched Jobs].
Thanks for the help!
Bob
I'm looking for a way to build a report that will find which City names I haven't matched for each record in a separate table.
I have 3 tables and 1 query involved to solve this problem, one containing my clients job details [Client Data], one containing the other cities jobs [Competitor Data], one with the matches between the client jobs and competitor cities [Matched Jobs], and one (query) with a unique list of competitor Cities [Unique List of Competitor Cities].
So, how do I build a report to tell me, by record in Client Data, which cities I do not currently have a match for from [Matched Jobs].
Thanks for the help!
Bob