Cant Pull Any Data

ddrew

seasoned user
Local time
Today, 10:21
Joined
Jan 26, 2003
Messages
911
Im having trouble with this Querry. I cnt seem to get any data out even though I know its there!
Code:
SELECT tbl_IncidentData.BoxNo, tbl_IncidentData.ReportedAt, tbl_IncidentData.FaultRectified, DateAdd("n",10,[ReportedAt]) AS Expr1, tbl_IncidentData.ExerciseID, tbl_IncidentData.IncidentDate
FROM tbl_IncidentData
WHERE (((tbl_IncidentData.FaultRectified)=False) AND ((DateAdd("n",10,[ReportedAt]))<=Time()) AND ((tbl_IncidentData.ExerciseID)=[Forms]![frm_ExerciseData]![ExerciseID]) AND ((tbl_IncidentData.IncidentDate)=[Forms]![frm_ExerciseData]![ExerciseDate]));
 
How are you calling this sql? Is this the code from an actual query or are you running it in vba?
 
It was from an actual query
 
Well I suggest removing all the criteria and add it back one at a time to identify which filter is not working. Kind of process and ellimination
 

Users who are viewing this thread

Back
Top Bottom