Converting text value into date within query

[FrozenMana]

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, [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:

Undefined function 'Left' in expression

 

[pbaldy]

That sounds like a reference problem:

http://www.accessmvp.com/djsteele/AccessReferenceErrors.html

 

[James Deckert]

Check Paul's suggestion, but also make sure the VBA compiles ok. Also "compact and repair" the DB.

 

[FrozenMana]

I thought I updated all of the references. Thank you!

 

[pbaldy]

Happy to help!