Month end date format

[angie_oet]

Dear all,
Question for you all.
My Microsoft Access have:-
Contract start date
Contract end date
Status of combo box - Active, Expired

I would like the combo box can automate base on contract end date. Question here. The combo box only auto change to "Expired" once month end reached.

Example:
Contract start date 01 Jul 06, Contract end date 25 Jul 06. From here, I do not want the combo box base on system date to change it to "Expired". Only when the month end reached, system will auto change it. For your information, not only 1 record, I have 100++ of records & start from different contract date.

Appreciate your help.

Angie

 

[RV]

Contract start date 01 Jul 06, Contract end date 25 Jul 06

Which means that the contract expires on 25 Jul 06, not on 31 Jul 06...

PS Next time, post your thread in the appropiate forum.

RV