How to get new year date

[Huayang]

How to calculate new year date when the year from year 2006 to 2007, after
my Access 2000 program get new year date and automatically set var value to
0.

Thanks

 

[John W. Vinson]

How to calculate new year date when the year from year 2006 to 2007, after
my Access 2000 program get new year date and automatically set var value to
0.

Thanks

Please explain. It is not clear what you are asking. To get the year number
from a Date/Time field use

Year([datefield])

I have NO idea what you mean by "set var value to 0".

John W. Vinson [MVP]

 

[Huayang]

I mean that when from this year 2007 into year 2008, my Access 2000 program
can automatically set integer Var value to 0.

How to calculate new year date when the year from year 2006 to 2007, after
my Access 2000 program get new year date and automatically set var value to
0.

Thanks

Please explain. It is not clear what you are asking. To get the year number
from a Date/Time field use

Year([datefield])

I have NO idea what you mean by "set var value to 0".

John W. Vinson [MVP]

 

[John W. Vinson]

I mean that when from this year 2007 into year 2008, my Access 2000 program
can automatically set integer Var value to 0.

Do you want this to happen at midnight on January 1?

What if the database is not open?

Do you want the var to be set when you open the database for the first time in
2008?

Where and how is this "var" used?

Huayang, *you* can see your database; you understand what it is intended to
do. We do not. Please explain the context - what you are trying to ACCOMPLISH.

John W. Vinson [MVP]