Hi All
I am using a query to compare the "Address" field in 2 tables "TblCustomersNoDuplicates" and "TblCompletedJobsAddressed"
The query below works fine but I would like to have all duplicated addresses displayed
I attend households and businesses to complete service work, therefore, there may be several identical addresses In "TblCompletedJobsAddressed" my goal is to have all identical addresses displayed in a continuous form so that I can see what has been repaired in the past compared to the new work request.
The new work request is in "TblCustomersNoDuplicates"
SELECT [TblCompletedJobsAddressed].Completed_Date, [TblCompletedJobsAddressed].JobNo, [TblCompletedJobsAddressed].[CustomersName], [TblCompletedJobsAddressed].[CustomersAddress], [TblCustomersNoDuplicates].[CustomersAddress]
FROM TblCompletedJobsAddressed INNER JOIN TblCustomersNoDuplicates ON [TblCompletedJobsAddressed].[CustomersAddress]=[TblCustomersNoDuplicates].[CustomersAddress]
WHERE ((([TblCustomersNoDuplicates].[CustomersAddress]) Like [TblCompletedJobsAddressed].[CustomersAddress]));
DavRob
I am using a query to compare the "Address" field in 2 tables "TblCustomersNoDuplicates" and "TblCompletedJobsAddressed"
The query below works fine but I would like to have all duplicated addresses displayed
I attend households and businesses to complete service work, therefore, there may be several identical addresses In "TblCompletedJobsAddressed" my goal is to have all identical addresses displayed in a continuous form so that I can see what has been repaired in the past compared to the new work request.
The new work request is in "TblCustomersNoDuplicates"
SELECT [TblCompletedJobsAddressed].Completed_Date, [TblCompletedJobsAddressed].JobNo, [TblCompletedJobsAddressed].[CustomersName], [TblCompletedJobsAddressed].[CustomersAddress], [TblCustomersNoDuplicates].[CustomersAddress]
FROM TblCompletedJobsAddressed INNER JOIN TblCustomersNoDuplicates ON [TblCompletedJobsAddressed].[CustomersAddress]=[TblCustomersNoDuplicates].[CustomersAddress]
WHERE ((([TblCustomersNoDuplicates].[CustomersAddress]) Like [TblCompletedJobsAddressed].[CustomersAddress]));
DavRob