General Question regarding Access Queries

[CBG2112]

I created a standard query with the following SQL

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"));

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.

 

[vbaInet]

I think the problem stems from the date criteria. Wrap them in hash (#) characters and see if that solves your problem. If it doesn't you can also use the Format() function to format it to a US date format.