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.

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