Format function is not working.

[rsampathy]

Below function does not work in few machines of Access 2007 version.
SELECT Format([Date],'mmm yy') AS Expr1 FROM table1;

Error message : Format function not exist.

Re-installed Access2007 still same problem.

Please any suggestion.

REgards,
SAM.

 

[vbaInet]

Change the name of your [Date] field to something else, e.g. JoinDate. It is probably clashing with Access' date function.

 

[DCrake]

Also you may need to check your references to make sure you have no "Missing" ones.