Search results for query: *

Hi guys. I haven't posted anything here for years so sorry if this has come up before. I have a report in excel used in a call centre that tracks the number of calls an agent makes. Team Leaders want to see performance by month on a chart. I have a chart that has an offset formula to change...

Hi. I have Win XP Home (I know its not pro but I couldn't find an XP home forum) and I have a wierd problem. With some of my applications, when I open them they flash up for a second and then close down again automatically and I can't get them to stay open. The applications are completely...

Hi. I need to compare a cuurent record to a record 2 records back. Obviously I can get 1 back by using the "previous" command but I don't know how to go further. I tried to create a calculated field @previous1 and then take a previous of that field by creating @previous2 but it did...

Hi. I am trying to modify a report by displaying 3 calculated fileds on it. Not all calculated fields will return a value, and I only want the fileds that do have a value to be displayed. ie. I do not want any records on the whole report unless there is data in the calculated colums. So I...

I have just imported my mail, address book and accounts from outlook express to outlook 2000. In Out Exp when I typed in the first letter of anyone in the contacts list of my address book their name would automatically populate. This feature does not seem to be working with Outlook 2000...

Hi. I have a report that runs every day for yeasterday and I need to be able to change it to a demand report so that I can run it for a selected day. I have deleted the VW_EVT_AGENT_ACTIVITY."AA_TIME_STAMP" >= TRUNC(SYSDATE) -1 AND VW_EVT_AGENT_ACTIVITY."AA_TIME_STAMP&quot...

Hi. I have ZA 3.01 and some sites eg. http//:www.tradingpost.com.au will not load properly. The home page loads but the drop down selections on the home page do not load properly. Also If I search for something it brings up the search results but if I try to click on one of the results it...

At the contact centre I work in we measure the longest delay a call waited each day, and then at the end of the week the longest delay of the week is measured. What I need to know is can the maximum delay be found by week over several weeks. eg. Delay by Day Week Result I Want 1256...

I am trying to get excel to access another application and copy a list of records. The only way to copy the records within the other application is to right mouse click i.e. there is n way to access it from the tool bar. Does anyone know what code I can use to get the right mouse click menus...

Does anyone know of a way to find the Maximum of a range depending on a certain criteria. Ideally I wish there were a MAXIF formula that worked in the same way as a SUMIF. I need to be able the find the max based on a series of records by date. Eg. Find the MAXIMUM "X" on July 01...

I am trying to get my code to log into SAP just by copying and pasting the user name and password and then get it to run a SAP report. While the SAP report is running the cursor hour glasses and I need to use the values from the SAP report which are available when the cursor stops hour...

Hi. I have changed my report from a scheduled report to a demand report by adding in a start and end date in the parameter fields and select expert and then deleting the truncate sysdate in the SQL. Now when I run the report it fails and the error message in the properties reads...

Hi. I have just finished a photo gallery that I want to be able to view through a web site that I already have. The photo gallery is not related to the existing site so I don't want a link from anywhere on the site. I have named the main page photoalbum.html and when I type in the website and...

Hi. I have just finished a photo gallery that I want to be able to view through a web site that I already have. The photo gallery is not related to the existing site so I don't want a link from anywhere on the site. I have named the main page photoalbum.html and when I type in the website and...

Hi. I am new to GoLive and web development and was wondering if anyone knoew of any free on-line tutorials, or anywhere one could be downloaded. Thanks Dandas

I am trying to get the :mm: of a time field (which is hh:mm:ss)to round up or down to the nearest half hour depending on which period it is in. So I need the minutes to be "00" if it is between 08:01 and 08:30 or "30" if between 08:31 and 09:00. I am using the following...

Here is one that is probably simple to most of you. I need to concatenate a formula which is a half hour period ending i.e. 10:00 or 08:30 with a field which is a number i.e. 101 or 999. I have been trying using the following formula...

Hi. Like alot of people I am relatively new to crystal and I use it for call centre reporting off a Rockwell switch. I am trying to roll up into 1/2 hour periods a whole lot of event data that is recorded when an agent punches a code into their phone. So I need to get the time format to end...