...

View Full Version : SQL date query



cr-222
03-08-2005, 05:45 PM
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



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum