98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » Undefined function format in expression
Undefined function format in expression
Resolved · Low Priority · Version Standard
Faith has attended:
Access Introduction course
Undefined function format in expression
I wish to format the date of a Date/Time field in a query
for display purposes on a graph.
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"))
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Compact database automoaticallyTo ensure optimal performance, you should compact and repair your |