FrozenMana
Registered User.
- Local time
- Today, 14:34
- Joined
- Aug 10, 2015
- Messages
- 27
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:
however the query is now giving the error message:
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:
Code:
SELECT qryValidZips.ZipCode, EMP013.HSAHBCD, [COLOR="Red"]Left([HSACHDT],10) AS Expr1[/COLOR], 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
HAVING (((EMP013.HSASTAT)="ACTV"));
however the query is now giving the error message:
Code:
Undefined function 'Left' in expression