By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,483 Members | 3,312 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,483 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?
Mar 12 '19 #1
Share this Question
Share on Google+
3 Replies


twinnyfo
Expert Mod 2.5K+
P: 3,284
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!
Mar 12 '19 #2

ADezii
Expert 5K+
P: 8,638
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, 22 views)
Mar 12 '19 #3

P: 2
Twinnyfo, Thanks for confirming my thoughts. Just a "fun" project to try for a calendar db.
Mar 13 '19 #4

Post your reply

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