Simple Calendar in MS Access - how to see all dates and times?

[Guest]

Does anyone know how to do this? I want to create a query that not only
shows me what is being done but what also shows times I'm free. the result
should look something like this:

December 24, 2005
1AM - take dog for a walk
1:30AM - have lunch
2AM
3AM

I think the answer is to have 2 tables linked somehow. One that shows all
the times in a day (ie. 1AM, 2AM, 3AM etc). And another that shows what
events are set at what date/time (ie. 12/24/05 1AM - take dog for a walk,
12/24/05 1:30AM - have lunch).

How do I connect these together? Please advise. Thanks and Merry
Christmas.
Peter

 

[RuralGuy]

Does anyone know how to do this? I want to create a query that not only
shows me what is being done but what also shows times I'm free. the result
should look something like this:

December 24, 2005
1AM - take dog for a walk
1:30AM - have lunch
2AM
3AM

I think the answer is to have 2 tables linked somehow. One that shows all
the times in a day (ie. 1AM, 2AM, 3AM etc). And another that shows what
events are set at what date/time (ie. 12/24/05 1AM - take dog for a walk,
12/24/05 1:30AM - have lunch).

How do I connect these together? Please advise. Thanks and Merry
Christmas.
Peter

Have a look at this link:
http://www.invisibleinc.com/download.cfm?filFilID=6

Merry Christmas to you too Peter.
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.