Undefined Function Format Error

  • Thread starter Thread starter Neill M. Pinkney
  • Start date Start date
N

Neill M. Pinkney

I wish to format the date of a Date/Time field in a query
for display purposes on a graph. The format I require is
Jul '03

Whilst things work fine on my machine, when I port the
application to another machine, the query gives the error
message:-

"Undefined Function Format in expression"

In fact the other machine returns an error with and
expression using Format(). What setting controls this so
that I can change it on the offending machine?

My machine runs Access 2000 (Office 2000 Premium) on NT4
The other machine Access 2000 (Office 2000 Pro) on Win2000

My row source SQL says:-
TRANSFORM Count(*) AS [Count] SELECT (Format
([edDateTime],"mmm"" '""yy")) AS MYDATE FROM [qryStats]
GROUP BY (Format([edDateTime],"mmm"" '""yy")) PIVOT
[qryStats].type;

My resulting expression in the Expression Builder:-
MYDATE: (Format([edDateTime],"mmm"" '""yy"))
 
"Undefined Function Format in expression"
Click to expand...
This appears to be the very common References bug. Open any
module in design view, or open the VBA editor by typing
Ctrl-G. Select Tools... References from the menu. One of the
..DLL files required by Access will probably be marked
MISSING. Uncheck it, recheck it, close and open Access.

If none are MISSING, check any reference; close and open
Access; then uncheck it again. This will force Access to
relink the libraries.
 
Back
Top