Calendar reporting question

[Mark Andrews]

Here's a general question related to doing reporting off calendar events.

I am using a third party calendar control which allows for recurring events
(example: event occurs every 2 days for 3 occurrences)
where this information is stored as:
- one event record
- one recurrencepattern record

My question is:
I now want to do some standard Access reports off calendar events such as
list out the events that occurred
Dec 1st 2008 thru Dec 31st 2008. However I would like recurring and
non-recurring events to be listed.

I wondering what the best way to approach this is? The recurring events
being the tricky ones.

Note: There are a fair number of ways to setup recurring events.

I have a few ideas but I thought I would ask, maybe someone has gone down
this path before.

Thanks in advance,
Mark

 

[a a r o n . k e m p f]

you basically need to cartesian the recurring events table, combined
with a dates table-- in order to generate the events that you want

btw, SQL Server has the most advanced scheduled capabilities-- this is
built in functionality.
If you want to run code every 2 hours on weekdays; this is built in
functionality (in the gui) for SQL Server.

Or you can stick with an obsolete database and reinvent the wheel.

-Aaron

 

[Allen Browne]

Mark, take a look at this and see if it is any use to you:
http://allenbrowne.com/AppRecur.html

The article suggests a few ways that recurring events can be handled, and
suggests a solution that copes with:
- recurring events that don't have a termination date, and
- recurrences where some are cancelled or rescheduled.

 

[Mark Andrews]

Allen,
Thank you, thank you, thank you!

I just glanced at your article, I'll need to digest it a bit more but I'm
glad to know that others have tackled this a bit in the past. Perhaps if I
fully tackle my problem I'll write up the resolution and send it to you for
your site.

Not sure why I didn't look on your site to begin with, it's usually the
first place I go?

Thanks again,
Mark

 

[Mark Andrews]

Thanks for the advise on the cartesian.

I can't use SQL Server for this solution because the targeted customers will
not have SQL Server.
I love SQL Server but it's not a fit for all solutions. I need a desktop
database and I think Access is the best choice.

You might think about a new year's resolution to improve your additude about
Access. Maybe cut back and only say bad things
on 1 out of every 3 posts. Just a thought?

Mark

message
you basically need to cartesian the recurring events table, combined
with a dates table-- in order to generate the events that you want

btw, SQL Server has the most advanced scheduled capabilities-- this is
built in functionality.
If you want to run code every 2 hours on weekdays; this is built in
functionality (in the gui) for SQL Server.

Or you can stick with an obsolete database and reinvent the wheel.

-Aaron

 

[a a r o n . k e m p f]

SQL Server is free-- just as free as Jet is--

and there is _NO_ such thing as a desktop database.

-Aaron