Search results for query: *

Hello I have a crystal report with data from an Oracle database. I have created a query in MS Access in the exact same structure as the datasource from Oracle and need to do a union query. How do I do that? I can use the "Add Command" but it throws me an error that it can't find the MS...

Is there a way to get the record count using pass through query? I am getting data from Sybase, creating a temp pass through query then using that query to insert the records into my local access table. Will I need to re-query the temp pass through query to get the count or is there a way to...

I don't really know if it falls under this category - oh and not to mention I'm not the Symposium tech guy (gal). I just do reporting. Is there any way to have the phone set up so that when the caller disconnects, the agent's phone line remains 'live' for a few seconds then he/she either...

I want to create a (new) accdb file that I can put on a scheduler to autoexec the code to copy and compact various accdb files in different servers. I am stuck at the part of connecting to the database. This is the code I had before: Public Sub doCompact() Dim JRO As JRO.JetEngine Set JRO =...

I created an accde file - The form has command buttons with hyperlinks to an executable file (captivate video files for my help files). From the accdb format, I can click on the button and it follows the link no problem but when I create the accde version of the same accdb file, the...

This is driving me nuts. I have a table with the following fields: MainID --> numeric ID FileAttachment --> attachment type field. In a new form, all I want is to show the different attachments per record. Right now, I only have 1 record that has 3 attachments. 2 command buttons to go...

How do I do this? I want: If combobox.column(1) IN listbox.column(1) then do what I want Else Exit function End if My head hurts I can't figure it out.

Does anyone know if there is an absolute certain way to determine whether the call was released by an agent rather than the caller? If I search in the Call by call, I see Local Call Released but I can't assume that the agent did the 'releasing' or vice versa. Thanks in advance.

I have 5 combo boxes with labels that are currently piled on top of each other. On click of a command button I want a combo box with its corresponding label to "move" or reposition to a certain spot on the form. I set the top and left property of the control and label on the On click event of...

I have an unbound combo box that looks up value from a table. I have also enabled the Not In List event to allow users to add to the list as necessary. If the user selects a value that is IN the list, I want to disable some other controls on the form. How do I do this? Thanks in advance.

I have an agent whose total logged in time equals 15 hours and 17 mintues on the dAgentPerformanceStat table. I naturally assumed that maybe she left herself logged in and never logged out. I ran the login/logout report which shows she logged in at 8 am and logged out at 4:30 pm. I ran the...

I feel silly asking this but I need to confirm. I'm creating an agent level report for our managers. Can someone confirm please: Calls offered/presented MINUS Calls answered should equal: Calls requeued by agent + Calls requeued due to timeout + Abandoned (I cannot find this field. Unless...

Hi there, I am new to Symposium, only been working with it since July 14 this year. And ONLY from the reporting side, nothing administration. Our telecom specialist is on vacation so I can't ask him (we are a small call center), but I'm pretty sure he said we are converting to version 6 in Q1...

Hello I am looking at grabbing data by application for AbandonDelay2, AbandonDelay4, etc., same with AnswerDelay2, AnswerDelay4 etc. Based on the data dictionary, these are counts of calls abandoned or answered after waiting for a period less than or equal to the number of seconds specified...

I am attempting to get a near 100% breakdown of time an agent spends logged in. My goal is to break it down by percentage as follows: Log in time = Skillset Talk Time + Not Ready Time + DN Talk Time + Waiting Time etc. I am pretty close to balancing these times into the Log In Time, but...