How do I update a Calendar with dates?

[niftysam]

I have a db which holds event dates, and I need a way to be able to tell if any dates overlap? Any ideas?? Thank!


- SAM

 

[Crilen007]

It depends on how the dates are entered, and what you mean if they overlap.

Are they on the same form? in a table? in separate tables?

Where are these dates, and how are they entered? And when/where do you want to see if they overlap?

 

[EmmaJane]

You may find this thread of help, also follow the link at the end of it


http://www.access-programmers.co.uk/forums/showthread.php?t=44656&highlight=dates

 

[niftysam]

Clarification

The dates are entered in the Table: Event as BeginDate and EndDate.

What I mean by overlap is if Event 1 starts 12/3/04 and ends 12/6/04 and Event 2 starts on 12/5/04 then Event 1 and Event 2 would overlap.


Thanks for the interest!!

 

[niftysam]

More info

One more thing. Events can and will overlap, but I just want to be aware of them and I dont know the best technique. Again, I thank everyone for their ideas!