Trouble with Multiple Dates

[janet K]

I am working on making a database for events that we get invited to. Some of them only happen once for one date, others are 3 or 4 days in a row, while others are all the weekends in october.

What is the best way to store this if someone wants to go in and put in a date or date range and find out all of the events that are happening for those dates.

Now that I am typing this I am thinking that the date and time should be in its own table? While the other event information is in anohter table.

Any suggestions would be greatly appreciated.

[Søren Dyhr]

First of do you know that join-tables can be omitted and be replaced with fields holding value's based mathematical expressions, and why and when to do so??

This really will take you deep into relational approaches a la Filemaker, and you could study this template where some measures in that direction is shown:

http://www.fmforums.com/forum/attachment.php?attid/7281/

...as well as recursive customfunctions - say like LeCate's CF here:

http://www.clevelandconsulting.com/support/viewtopic.php?t=739

--sd