appointments-query

appointments-query

SELECT DISTINCTROW Appointments.AppointmentID AS qAppointmentID, Appointments.EmployeeID AS qEmployeeID, Appointments.CustomerID AS qCustomerID, Appointments.PetID AS qPetID, Appointments.AppointmentDate, Groomers.FirstName AS Groomer, Appointments.StartTime AS [Time], YesNo.Value AS [S Appt], IIf([comments] Like "** call the office **","CALL THE OFFICE",[Last Name]) AS Customer, Pets.PetName AS Pet, Breeds.Breed, "(" & [Customers].[MAPSCO City] & ") " & [Customers].[MAPSCO] AS qMAPSCO, Appointments.Comments, Appointments.Dip AS qDip, [Mapsco Color].[MAPSCO Color], YesNo_1.Value AS Pref
FROM ((((((Appointments LEFT JOIN Groomers ON Appointments.EmployeeID = Groomers.EmployeeID) LEFT JOIN Pets ON Appointments.PetID = Pets.PetID) LEFT JOIN Breeds ON Pets.BreedID = Breeds.BreedID) INNER JOIN [YesNo] ON Appointments.StandingAppt = YesNo.Argument) LEFT JOIN [Customer Query + Mapsco4] ON Appointments.CustomerID = [Customer Query + Mapsco4].CustomerID) LEFT JOIN [Mapsco Color] ON ([Customer Query + Mapsco4].MAPSCO4 = [Mapsco Color].MAPSCO) AND ([Customer Query + Mapsco4].[MAPSCO City] = [Mapsco Color].[MAPSCO City])) INNER JOIN [YesNo] AS YesNo_1 ON Appointments.UsePreferredGroomer = YesNo_1.Argument
WHERE (((Appointments.EmployeeID) Like [Forms]![Appointments]![Groomers]) AND ((Appointments.AppointmentDate)>=[Forms]![Appointments]![FromDate2]))
ORDER BY Appointments.AppointmentDate, Groomers.FirstName, Appointments.StartTime;