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

Creating a calendar with multiple date fields

P: 2
If you have data about a person including a Birth-Date, Anniversary-Date, Other-Date, in their own fields, can you create a monthly calendar showing such. Would it be better to have a date table that only has one date field and other fields to identify the person and date meaning?
1 Week Ago #1
Share this Question
Share on Google+
3 Replies


twinnyfo
Expert Mod 2.5K+
P: 3,054
Dromas,

Welcome to Bytes!

I always prefer to have "taller" tables than "wider" tables. In your example, having a separate table for dates makes more sense than having many fields for each date. Here is the reason, while everyone has a birthdate, not everyone has a wedding date or a graduation date, or a "Crowned World Heavyweight Champion of the World" date. In such cases, you have empty fields that may never contain data.

Thus, you could have a Table called tblDates with only a few fields:
Expand|Select|Wrap|Line Numbers
  1. PesonID
  2. EventType (foreign key to another table listing different types of dates)
  3. EventDate
  4. Comments
Thus you could add as many Event Types as you wish and never have to worry about changing your table structure.

Now, making a calendar in Access--this is an entirely different story. Many have attempted such a thing unsuccessfully. It is not an easy thing.

Hope this hepps!
1 Week Ago #2

ADezii
Expert 5K+
P: 8,597
Now, making a calendar in Access--this is an entirely different story. Many have attempted such a thing unsuccessfully. It is not an easy thing.
So very true. I have an Access-based Calendar that I have personally adapted for various uses over the years. I made some simple modifications to display Birthdays in the Month of March only. The Calendar derives it's info from tblData which consists of only three Fields, [Last], [First], and [BDate]. Have fun.

P.S. - The Logic can be expanded to include multiple dates along with their types: Anniversary, Birthday, Wedding, etc. This would definitely add another layer of complexity, however.
Attached Files
File Type: zip Birthdays.zip (125.8 KB, 8 views)
1 Week Ago #3

P: 2
Twinnyfo, Thanks for confirming my thoughts. Just a "fun" project to try for a calendar db.
1 Week Ago #4

Post your reply

Sign in to post your reply or Sign up for a free account.