travis! here it is
hi travis,
so what i understand is that i should attach your sql code to the end of my sql for this query, here is my sql code
SELECT Companies.CompanyName AS SITE, LogHeader.LogDate AS [CALL DATE], LogHeader.LogHeaderID AS LOGNO, Format([LogTime],'hh:nn:ss') AS [CALL TIME], Left([ARAccount],6) AS [SITE IDASS], LogDetail.Comments AS DESCRIPTION, Format([ArriveTime],'hh:nn:ss') AS [START TIME], Format([CompletedTime],'hh:nn:ss') AS [FINISH TIME], Format([ArriveDate],'Short Date') AS [RESPONSE DATE], ([logheader].[completeddate]+[completedtime])-([arrivedate]+[arrivetime]) AS DURATION, LogHeader.Parent AS PARENT, LogHeader.Child AS CHILD, LogHeader.Status AS STATUS, " " AS IN_OUT, " " AS [IN_OUT ELAPSED], Chr(13) & Chr(10) AS Expr1
FROM ((((LogHeader INNER JOIN LogDetail ON LogHeader.LogHeaderID = LogDetail.LogHeaderID) INNER JOIN Companies ON LogHeader.CompanyID = Companies.CompanyID) INNER JOIN Jobs ON LogHeader.JobCode = Jobs.JobCode) INNER JOIN Addresses ON Companies.CompanyID = Addresses.CompanyID) INNER JOIN LogServiceType ON LogHeader.ServiceType = LogServiceType.ServiceType
WHERE (((Companies.CompanyName) Like "*MOBIL*") AND ((LogHeader.LogDate) Between [Enter Start Date] And [Enter End Date]) AND ((Addresses.Address4) Is Null Or (Addresses.Address4)=[Enter State eg VIC]) AND ((Jobs.Description) Like "*CARWASH*") AND ((LogDetail.DetailType)="O")) OR (((Companies.CompanyName) Like "*MOBIL*") AND ((Format([ArriveDate],'Short Date')) Between [Enter Start Date] And [Enter End Date]) AND ((Addresses.Address4) Is Null Or (Addresses.Address4)=[Enter State eg VIC]) AND ((Jobs.Description) Like "*CARWASH*") AND ((LogDetail.DetailType)="O") AND ((LogHeader.CompletedDate) Between [Enter Start Date] And [Enter End Date]))
ORDER BY Companies.CompanyName, LogHeader.LogDate, Addresses.Address4, [logdate]+[LogTime];