Undefined Function Format Error

  • Thread starter Neill M. Pinkney
  • 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"))
 
J

John Vinson

"Undefined Function Format in expression"
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top