Recent content by bistro7

Got it....that worked; thanks for you help.

trangamer, great idea...I got the code to work and it is working fine with the exception of one issue. The query is constantly running and is flashing every second. Is there a way to have this run just once every 15 minutes or just to run when the interval changes?

traingamer, thanks this is intersting. I am going to have to try this. I will follow-up when I get back in tomorrow.

Thanks..qryNewSch displays the schedule for the team each interval. The query runs each time the interval changes and displays the updated schedule for that specific interval. The schedule is diplayed on a large monitor. The trigger to run the query is the interval change (timer control). What I...

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

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

Skip thanks for your help. This worked.

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!

Sean thannks for the reply. It looks like I will have to use my SL calc also.

Thanks to both for providing the information. It helps alot! My next problem is where to track then "FLOW IN" calls. Do you know if the flow in calls answered in the ACD?

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

Quehay, thanks for the response, but when I run the query I am getting the total count for the number of occurances of the same date. e.g. For the below example I get a total of 3 instead of an increment count of 1,2,3. Any ideas? Date 9/5/03 9/5/03 9/5/03

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