Search results for query: *

Thanks Skip. I'll try it and let you know. Gary

Hi, I have the task of creating an excel formula to spread total value for each contract over 24 month columns....i.e 2010 and 2011. Based on start date. The amount needs to be spread Monthly,quarterly, semi-annually or yearly dependng on the terms of the contract. I am not sure if this can be...

Thanks Skip I'll repost on the other forum too Here is a sample of the date Contract Start Date Amount Type A 1/20/2010 $1000 Quarterly B 2/10/2010 $2000 Semi Annually C 4/01/2010 $3000 Monthly D 3/23/2010 $5000 Yearly

Hi, I have the task of creating an excel formula to spread total value for each contract over 24 month columns....i.e 2010 and 2011. Based on start date. The amount needs to be spread Monthly,quarterly, semi-annually or yearly dependng on the terms of the contract. I am not sure if this can be...

Heston, I will try that and see. Thanks a bunch! Gary

Hi, I am trying to generate a diagram of tables and a relationships of an existing SQL 2000 database. What is the best way to accomplish this ...I would appreciate your help."Diagrams" option in Enterprise Manager shows no items. Thanks Gary

Hi, I am trying to generate a diagram of tables and a relationships of an existing SQL 2000 database. What is the best way to accomplish this ...I would appreciate your help."Diagrams" option in Enterprise Manager shows no items. Thanks Gary

Hi, I am of the understanding that when I use excel connection manager, the path is mapped to the SQL server tables using OLE DB. Once the table is selected, excel creates a copy of the table on the worksheet. This table is independednt and doesnt have a live connection with the SQL server...

Hi, I am in the process of linking Excel spreadsheet with a SQL database using Connection manger. I have few concerns about this: 1) Is the ODBC connection link a two way connection? 2) If yes, if I update or change any field will it overwrite the information in the SQL databse? Looking...

Gavin, Thank you so much!! It works now!! Cheers, Gary

Skip/Gavin Sorry for the confusion, maybe I wasn't clear in my explanation. From the example. I want to match data from column 1 and column 2 having 'Buffalo' and 'NewYork' to update the formula column with 'Chicken Wings' and every thing other than 'Buffalo' and 'New York' will be updated with...

Hi!! I am looking for an excel fomula to accomplish the following. I have two cloumns with information and if I have matching value in the 2 columns I would like to assign a value to the corresponding cell otherwise it will update the cell with what's in column2. Example: Column1...

Hi, I am trying calculate due date of invoices based on the invoice date. for e.g if the date is 1/13/05. I was wondering if there is formula that will automatically calculate the due date 30 and 45 days from the date of the invoice. Any input in this respect I will appreciate, Thanks in...

Thanks for your responses, It started to work now, the Backup exec server was paused for some reason. I had to start it back under the devices tab, for it to work again. Gary

Hi, The regular backups just don't inititate, it remains "scheduled" even after the start time. If they do run, they are listed as cancelled due to the service shutdown. I am unable to find an error log or any other indication to show where the problem is originating from.I am using...

Hi, The problem is fixed it was simple tape loading issue. The tape wasn't seated properly and Backup Exec threw the device offline. I rebooted the server and before it loaded the OS i was able to eject the tape. Some reason Backup Exec was preventing the tape from being ejected and showed the...

Its a single tape device and somehow I am unable to find the location for the online and offline settings you suggested. Please let me know if what you are refering to is in the control panel or its sopmething I should access through Backup Exec. Thanks, Jerry

Hi, My backup exec 8.6 shows the tapedrive in offline status. The backups were working perfectly for the last few months. Suddenly now the tape doesnt eject and the scheduled job remains on loading tape status for hours. The lights on the drive are illuminated so it not a power supply issue. I...

Hey ahalecitrix, Your absolutely right!!!! That was the problem, now after activating Terminal Services Licensing, RDP is working perfectly. Thanks a lot, I really appreciate it ! Gary [2thumbsup]

I'm having a peculiar problem with my backups using Backup exec 8.6 ver, although the byte count is close to normal i.e 10gb approx full and 3gb for differential The job status shows as failed due to the following reasons in the job log printout: Difference encountered in file data The file...