Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005

    Question Unanswered: Is it possible to create this Query?

    I have an Access database that contains individual records of all work items carried out within my team.

    I wish to create a query that monitors the Service level Agreements that are linked to to these work items.

    The Database Fields I wish to use are Start Date/Time compared to End Date/Time, these then need to be linked to the SLA for individual Call Types (ie) Password Resets or Logon Resets which are identified in the database field Call Type. I also have other call types which are affected by longer SLA's, but presume any solution can be tailored accordingly.

    The query would need to identify all calls which fall out of the SLA of 15 minutes for Password or Logon Resets.

    I do not know if this is possible and I am new to Database design, I do not have any VB skills but I am a good learner.

    I hope someone can help me

    Thankyou for taking the time to look at my query

  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    read about datediff() in the help file. Chances are it will do what you want.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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