Undefined function "format" in expression

Question

Hi,

I am using this query in my newly installed access database and getting the error as given in the subject line. This query was working fine in the old access database. Would you please advise me what is wrong with it. Same query is working on other laptops. I have checked trust center settings and all look ok. Please advise me.

Thanks for your help.

SELECT FirstDate, LastDate, LocationID_From, Destination, Movement_Type, Grade_Category, Format([CR_Tones],'#,0.00') as Tones, Format([Cr_Ounces],'#,0.00') as Ounces, Format([CR_Grade],'#,0.00') as Grade

From QRY_ProdDailyCrushedMaterialByDate_Mat

UNION SELECT 'Total' as FistDate, 'Total' as LastDate, 'Total' as LocationID_From, 'Total' as Destination, 'Total' As Movement_Type, 'Total' As Grade_Category, Format([CR_Tones],'#,0.00') as Tones, Format([Cr_Ounces],'#,0.00') as Ounces, Format([CR_Grade],'#,0.00') as Grade

From QRY_ProdDailyCrushedMaterialByDate_Total;

Answer 1

Go to - in the VB editor - menu Tools, References.

One or more reference is probably marked: MISSING.

Sort this out, and you won't see the error.

Answer 2

Hi,

try with  Format([CR_Tones],"#,0.00") as Tones

use " instead '

Ciao Mimmo