Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: bistro7
  • Content: Threads
  • Order by date
  1. bistro7

    Need a Way to LOOP This

    I am running this CASE from 6:00 a.m. to 5:00 p.m. updating a query every 15 minutes. The interval also updates by 1. e.g. 6:00-6:15 =1, 6:15-6:30 = 2, etc... I am looking for a way to put this in a loop for better coding. Any help would be appreciated. Select Case strInterval Case "06:00:00...
  2. bistro7

    Need to Understand SplitSkill Report

    Example: 2 Queues;"Sales" and "ALL". Agents with "Sales" have different priority 1 or 2. If NO priority 1 agents are available the call goes to an available priorty 2 agent. If NEITHER is avaialbe the call routes to the "ALL" agents queue after 60 seconds. Typically on 10 calls received: Flow...
  3. bistro7

    Need Help With Count Of Records

    I am trying to count the records in a query: ID WQ_ID RecordNumber 1 299704 1 2 299704 2 3 299705 1 4 299705 2 5 299706 1 6 299707 1 7 299707 2 8 299707 3 9 299707 4 The RecordNumber is what I am trying to pull, but I am having problems. Any help would be great!
  4. bistro7

    Flow In Flow Out Service Level

    I am having a problem with the service level being reported in my split/skil bcms vu report. The calc in help states: acceptable/offered * (100) and says offered = ACD + Flow Out + Aband. I am O.K. with that, but does anyone know where I account for the Flow In Calls? I have 47 Flow Out and 47...
  5. bistro7

    Query Increment Count

    I have a query with dates, where I want to incrementally get each occurrence of the same date. Here is an example of what I am trying to do: Any help would be appreciated! Date Count 1/5/03 1 1/5/03 2 2/10/03 1 2/27/03 1 3/9/03...

Part and Inventory Search

Back
Top