I have defined financial periods in table.
In this table i have defined 3 fields, 1-StartDate, 2EndDate, 3-ActiveDeactive. Field type of "ActiveDeactive" is set to Yes/No.
One record should be ON and remaining all OFF
I want to set any financial period as active period at any time
MS Access, P-4
May 28, 2010 12:03 PM
June 1, 2010 4:25 AM