I created a standard query with the following SQL
When I try to run the query on my machine, it shows only records that have a status other than "QC'd - OK" and "QC'd - Error Found". When i run the query on a separate machine, the query produces the desired results of records that have a status of "QC'd - OK" and "QC'd - Error Found." Can anyone give me some guidance to this issue I'm having. Thanks.
Code:
SELECT tblStatusHS.StatusDt, tblStatusHS.StatusUpdateUser, tblStatusHS.DOCS_REVIEWED, tblStatusHS.DOCS_ERROR, tblStatusHS.StatusTx, tblStatusHS.Batch_ID
FROM tblStatusHS
GROUP BY tblStatusHS.StatusDt, tblStatusHS.StatusUpdateUser, tblStatusHS.DOCS_REVIEWED, tblStatusHS.DOCS_ERROR, tblStatusHS.StatusTx, tblStatusHS.Batch_ID
HAVING (((tblStatusHS.StatusDt) Between Forms!frmReportsMenu!StartDate And Forms!frmReportsMenu!EndDate) And ((tblStatusHS.StatusTx)="QC'd - OK")) Or (((tblStatusHS.StatusDt) Between Forms!frmReportsMenu!StartDate And Forms!frmReportsMenu!EndDate) And ((tblStatusHS.StatusTx)="QC'd - Error Found"));