Hi I have a query that I pull from three tables. but it is showing duplicated records. The customer might have more than one workorder and this is causing my query to show duplicated records for customers.
here is the code
SELECT Calls.[Customer ID], Calls.[Customers Response], Customers.FirstName, Customers.LastName, Customers.[Home Number], Customers.[Cell Number], Workorders.[Service Call Date], Customers.[New Owner], Customers.[New Owner Letter Sent]
FROM Workorders INNER JOIN (Customers INNER JOIN Calls ON Customers.CustomerID = Calls.[Customer ID]) ON (Customers.CustomerID = Workorders.[Customer ID]) AND (Workorders.[Customer ID] = Calls.[Customer ID])
WHERE (((Workorders.[Service Call Date])<#1/1/2015#));
I want to have only one customer records to show if the workorders service call date is <1/1/2015.
Thanks Angie