Helpful Information
 
 
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










privacy (GDPR)