General Question regarding Access Queries

CBG2112

Registered User.
Local time
Yesterday, 21:56
Joined
Aug 4, 2009
Messages
32
I created a standard query with the following SQL
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"));
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.
 
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.
 

Users who are viewing this thread

Back
Top Bottom