best way to store time intervals

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

re: best way to store time intervals

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:--
Message posted via http://www.accessmonster.com