D
DS
I have an SQ Statement. It's a Query based on a SubQuery. I need to
make it all SQL by incorperating the Query into the statement. Any help
apprecited.
Thanks
DS
This is the SQL Statement
SELECT Query12.LogJobID, tblJobNames.JobName
FROM Query12 INNER JOIN tblJobNames ON
Query12.LogJobID=tblJobNames.JobNameID
GROUP BY Query12.LogJobID, tblJobNames.JobName
ORDER BY tblJobNames.JobName;
This Query12
SELECT tblTimeLog.LogDateIn, tblTimeLog.LogDateOut, tblTimeLog.LogJobID
FROM tblTimeLog
GROUP BY tblTimeLog.LogDateIn, tblTimeLog.LogDateOut, tblTimeLog.LogJobID
HAVING (((tblTimeLog.LogDateIn)>=[Forms]![frmTimeCardFilter]![TxtDate2])
AND ((tblTimeLog.LogDateOut)<=[Forms]![frmTimeCardFilter]![TxtDate3]))
OR (((tblTimeLog.LogDateIn)>=[Forms]![frmTimeCardFilter]![TxtDate2]) AND
((tblTimeLog.LogDateOut) Is Null));
make it all SQL by incorperating the Query into the statement. Any help
apprecited.
Thanks
DS
This is the SQL Statement
SELECT Query12.LogJobID, tblJobNames.JobName
FROM Query12 INNER JOIN tblJobNames ON
Query12.LogJobID=tblJobNames.JobNameID
GROUP BY Query12.LogJobID, tblJobNames.JobName
ORDER BY tblJobNames.JobName;
This Query12
SELECT tblTimeLog.LogDateIn, tblTimeLog.LogDateOut, tblTimeLog.LogJobID
FROM tblTimeLog
GROUP BY tblTimeLog.LogDateIn, tblTimeLog.LogDateOut, tblTimeLog.LogJobID
HAVING (((tblTimeLog.LogDateIn)>=[Forms]![frmTimeCardFilter]![TxtDate2])
AND ((tblTimeLog.LogDateOut)<=[Forms]![frmTimeCardFilter]![TxtDate3]))
OR (((tblTimeLog.LogDateIn)>=[Forms]![frmTimeCardFilter]![TxtDate2]) AND
((tblTimeLog.LogDateOut) Is Null));