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