Recent content by gk759

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