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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



On Sat, 24 Dec 2005 10:01:01 -0800, "wolftor"
<wolftor@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>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.
.



Relevant Pages

  • How to select another DatabaseName while running
    ... I want to be able to select another database for my query while running ... Peter ... Prev by Date: ...
    (comp.lang.pascal.delphi.misc)
  • Re: Do you want to be paired with Dene?
    ... Peter - ... Merry Christmas and Happy Chanukah anyway. ... Prev by Date: ...
    (rec.sport.golf)
  • Re: Data Relation
    ... query and displayed that. ... Not the most elegant way but it worked. ... Peter. ... Prev by Date: ...
    (microsoft.public.dotnet.languages.vb)
  • Re: syntax error in INSERT INTO statement
    ... William, what do you need this for? ... delete query? ... Peter ... Prev by Date: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Update table from ODBC
    ... Since you seem to be able to write a simple SELECT query on this, ... Change it to an append query and indicate the table ... > Thanks Peter ... Prev by Date: ...
    (microsoft.public.access.queries)