How can I install Weeknum function in access 2000?

[John Vinson]

Hello John,
Thanks for your answers, I create a table on my database with a macro which
will make the delete records+import excell workbook.It is working thanks to
you and Douglas, What is the easy way to use the record count from this table
in an other table ???
Thanks a lot

The easiest way is ... don't.

Storing a count in a table is neither necessary nor good design; as
soon as the workbook changes the stored count is WRONG.

Instead, count records on the fly with an expression

DCount("*", "[ExcelTableName]")

John W. Vinson[MVP]

 

[Guest]

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.