best way to store time intervals

[bubarnet]

Hi,
(sorry for my bad english)

I'm using access for a complex database, and I need to create a calendar.
For exemple :
from the 1st of january to the 14th of february, I need to store a yes/no
value
from the 15th of february to the 25th of february, another yes/no
....

The database can handle lots of people, each with one calendar. The calendar
run for several years.
Is it a good idea to store data for each day of each year ? Or is there
another way ?

Thanks

--
Bubar - Les Studios Du Wapiti
Création de sites internet et de logiciels multimédias
http://www.wapitistudio.com

[kingston via AccessMonster.com]

Would this structure work for you:

PersonID StartDate EndDate YesNoValue

You'll have to verify that start and end dates are valid, but this structure
seems more efficient that storing each day for every person. You'd simply
check that a date is between a specific start and end date to return the
yes/no value.
bubarnet wrote:

>Hi,
(sorry for my bad english)

I'm using access for a complex database, and I need to create a calendar.
For exemple :
from the 1st of january to the 14th of february, I need to store a yes/no
value
from the 15th of february to the 25th of february, another yes/no
...

The database can handle lots of people, each with one calendar. The calendar
run for several years.
Is it a good idea to store data for each day of each year ? Or is there
another way ?

Thanks

--
Message posted via http://www.accessmonster.com