Using SQL format function in Access 2003

[smashing_austin]

Hi there,

We've just converted our Access 2000 databases to Access 2003. A simple
SQL query:

Select ID, format(MaturityDate, "dd-mmm-yy") as MatDate

From MyTable

returns the error number 3085 "Undefined function Format in
expression".

I have no Missing references in Tools->References.

Any other suggestions as to how to use the Format function in Acess
2003?

Many thanks, Angela

 

[Duane Hookom]

I would go back and uncheck and re-check the references.

 

[smashing_austin]

I can't believe that was so simple - and it worked!! Thanks Duane =))