By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,183 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

best way to store time intervals

P: n/a
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
Dec 12 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Dec 12 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.