Category: Other Databases
SQL date query
I’m trying to create an MS Access SQL query that will return records of jobs that have a scale of work status (field: SCALEOFWORK) of 'High' and an initial visit date (field: DATEOFINTVISIT) that is greater than 2 days after the date that the fault was notified (field: DATEFAULTNOTF).
This is the coding produced so far:
SELECT JOBNO, DATEFAULTNOTF, NATUREOFFAULT, DATEOFINTVISIT, SCALEOFWORK, DATEWORKSTART, DATEWORKFIN, WORKCOST
FROM TBLJOB