Dear All,
SELECT workorderPR.prCol1, workorderPR.jobOrderNo, workorderPR.txtCol1, workorderPR.Date, workorderPR.cCode, workorderPR.prCol2, workorderPR.txtCol2, workorderPR.Date2, workorderPR.prCol3, workorderPR.txtCol3, workorderPR.Date3, workorderPR.Remark
FROM workorderPR
WHERE (((workorderPR.cCode) Like [Enter the cost code] & "*"));
The above is my query.in this query when i enter the cost code it display all the cost code records but i want in the same query first i enter the cost code and then ask ask the query enter the from date and to date . so that the query display the record based on date range.
From date field based on workorderPR.Date ( mandatory field) (yyyy-mm-dd)
and to date field based on workorderPR.Date ( mandatory field)
Please assist.