How can I install Weeknum function in access 2000?

[Nawel]

Hello John,
I will use this expression in a form or on the import table or in the excell
sheet ???

 

[John Vinson]

Hello John,
I will use this expression in a form or on the import table or in the excell
sheet ???

On a Form or Report, or in a Query based on the linked sheet. You
can't put expressions in a table, and this particular expression is
specific to Access, not Excel.

John W. Vinson[MVP]

 

[Douglas J. Steele]

I have a similar problem, or probably the same
I'm tring to use the weeknum funcion in access and it just don't work

The result is always: #Name?

Looks like if access do not recognize the function it self
Any advise ?

There is no Weeknum function in Access.

There's DatePart("ww", MyDateField) or Format(MyDateField, "ww")

DatePart returns a numeric value, Format returns a string.