Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
Thread: SQL date query
03-08-2005, 05:45 PM #1
- Join Date
- Mar 2005
- Thanked 0 Times in 0 Posts
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