Re: Date format to display month name

Tech-Archive recommends: Fix windows errors by optimizing your registry

If your db has any missing references, any VBA function used will result in
"undefined function" but it really means there are other functions not
defined because of the missing libraries. Fix the missing references and
your VBA code will work.

Chris
Microsoft MVP


reji wrote:
I am using Access 2000. In a query I have a field called docdate. I wish to
display this field's month name in same query as January, February, and so
on . So I typed the command Month:Format([docdate],'mmmm').
But when I try tun the query, getting error mesage - undefined function "
Format " in expression.

Please help me.

Regards,

Reji

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200805/1

.

Relevant Pages

  • RE: Query Question
    ... AvgAS AvgOfLineAvailPassFail ... FROM MasterAvailabilityData ... "Undefined function 'Left' in expression" ... First, in your query builder at the bottom, there is a row called Fields. ...
    (microsoft.public.access.gettingstarted)
  • RE: Query Question
    ... "Undefined function 'Left' in expression" ... First, in your query builder at the bottom, there is a row called Fields. ... instead of putting [TheField] in that cell we would put ... AName: ...
    (microsoft.public.access.gettingstarted)
  • Re: Query Question
    ... I tested her syntax for the date on a date field, ... "Undefined function 'Left' in expression" ... First, in your query builder at the bottom, there is a row called Fields. ... AName: ...
    (microsoft.public.access.gettingstarted)
  • RE: Query Question
    ... "Undefined function 'Left' in expression" ... SELECT LeftAS GrpValue, ... CountAS CountOfPMCode, ... First, in your query builder at the bottom, there is a row called Fields. ...
    (microsoft.public.access.gettingstarted)
  • Re: Query Question
    ... "Undefined function 'Left' in expression" ... "Klatuu" wrote: ... First, in your query builder at the bottom, there is a row called Fields. ...
    (microsoft.public.access.gettingstarted)