Results 1 to 2 of 2

Thread: Calendar's...

  1. #1
    Join Date
    Aug 2002
    Location
    UK
    Posts
    16

    Exclamation Unanswered: Calendar's...

    I am looking for an example db, if anyone has one that is... that contains an outlook style calendar (ie. displays all date and entries for one month) I would be grateful for any help or a push in the right direction
    "There Are No Problems only Solutions"

  2. #2
    Join Date
    Oct 2002
    Location
    Leicester - UK
    Posts
    820
    SELECT AccidentList.*
    FROM AccidentList
    WHERE (((Day([Date]) & "/" & Month([Date]) & "/" & Year([date])) Like [Accident Date? (d/m/yyyy) leave blank for all] & "*"));

    this is a usefull method for that sort of thing but if anyone can suggest a better method i wouldn't mind hearing about it
    Definition of a Beginner, Someone who doesn't know the rules.

    Definition of an Expert, Someone who knows when to ignore the rules.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •