My first time using this database as my coworker has fallen seriously ill and I am unable to ask them for help.
There is a query that is supposed to translate a text value into a date value. The value for the date is written in a 1yymmdd format in the file/table being used.
The following is the SQL query that is set up:
SELECT qryValidZips.ZipCode, EMP013.HSAHBCD, Left([HSACHDT],10) AS Expr1, EMP013.HSAOCAT
FROM qryValidZips, qryActiveHubs INNER JOIN (EMP013 INNER JOIN tblRefCoverageCategory ON EMP013.HSAOCAT = tblRefCoverageCategory.CovCatg) ON qryActiveHubs.HBMHBCD = EMP013.HSAHBCD
WHERE (((qryValidZips.ZipCode) Between [hsafrzp] And [hsatozp]))
GROUP BY qryValidZips.ZipCode, EMP013.HSAHBCD, EMP013.HSAOCAT, EMP013.HSASTAT
however the query is now giving the error message:
Undefined function 'Left' in expression