ASP/Access Calendar

[PhilgB]

I've already made a calendar with ASP and Access to hold the dates. However, when it comes time to enter an activity into the calendar which spans across more than one date, I need some ideas on how to detect and display this.

I'm not necessarily looking for code, just a train of thought to point me in the right direction.

Thanks!

[Bullschmidt]

Never did a calendar but here is an idea at least.

Perhaps now you are storing the starting date/time and also storing the number of minutes or the number of hours (i.e. the duration).

And you could still have that on the input form if you want as long as the form translates that into perhaps storing the starting date/time and the ending date/time.

Otherwise perhaps have the ending date/time calculated in a SQL statement.

[PhilgB]

Oops

[PhilgB]

Actually the form asks for the start time and the end time. The Calendar that is available to any hotmail account displays it as if an entry was added for each day in between the start and the finish. Although I doubt it was added each time in the database, I thought there might have been a better way of doing this.