Search results for query: *

All of the invoices are total up in one column: =Sum([fldAmtDue]) All of the Payments are totaled up in the next column: =Sum([fldBillPayAmt]) And the total amount due: =Sum([fldAmtDue])-Sum([fldBillPayAmt]) This works out just fine. However I was told by the Controller that he wants to...

At the bottom of my billing statement I want to show what is the amount due that is current, 30 days past due, 60 days past due, and 90 days past due. I was thinking the formula would be: Sum[AmtDue]-Sum[AmtPaid]<[End Date] or Sum[AmtDue]-Sum[AmtPaid] AND <[End Date] for the current due...

I have several rows shaded in an excel spreadsheet. I am using Excel 97. However when I print the shading is NOT showing up on the print out. I checked the page set up to be sure that the black and white option was NOT selected. It is not. Any suggestions how to fix my issue? Thanks. Kenny...

I did try it before I added the hosts table. I also tried by adding the hosts table one line at a time. Still no luck. The computer was connected to the network before I blew it away by another user. I also blew out all the dust bunnies from the maching and reseated the network card. I also...

I have a NT server that has mostly 98 machines logging into it. I replaced a very old 98 machine, with a new machine, 400 mhz, 32 RAM, and a fresh 98SE install. I copied the hosts table from one of the other machines at the facility, and tried to log into our server. It gets to the verifying...

No sorry, Needed the set limit to list to yes .... you dummy. <grin> Thanks for trying, sorry I was to dense. Kenny Renaud IT Manager Corral West Ranchwear Inc.

Thanks that worked!!! Kenny Renaud IT Manager Corral West Ranchwear Inc.

The limit to list property is "no" and it will let me add to the list but will not check to see if the name is already on the list. I feel like a big dope. Thanks for your help. Kenny Renaud IT Manager Corral West Ranchwear Inc.

Thanks. Unfortunatly that didn't help. I can type whatever I want in the box with no msgbox wanting to know if I want to add it when I hit enter and pop into another field. I know it is a weird one. Thanks!! Kenny Renaud IT Manager Corral West Ranchwear Inc.

I can add a new company without the msgbox popping up to say this isn't on the list are you sure you want to add it? I would like it to ask to keep misspellings etc out of the list. I used Dev Ashish's code with my own fld name, and table name: ' ************ Code Start ********** ' This code...

This is Win XP Pro edition. I have tried logging in as administrator with blank password and it only works in safe mode. Thanks for your help! Kenny Renaud IT Manager Corral West Ranchwear Inc.

I have a new machine that I am setting up. I have no problem connecting to the network. However, the issue is that the user should be able to be the admin of his own machine. I cannot log in as an admin on this machine except in safe mode, to install programs, adjust power settings ect.I have...

Thanks for the information! We really appreciate it. Kenny Renaud IT Manager Corral West Ranchwear Inc.

We have 5 servers, one at our corporate headquarters, one at Distribution Center and three for our e-commerce division. Currently they are all running NT4. We need to upgrade our corporate server to allow for upgrading our payroll software, and are looking at a Server 2003 machine, will it play...

Expr1: (([last updated]-[Start Date]+9.9)\36.525)/10 This is working with the exception noted above. Thanks. Kenny Renaud IT Manager Corral West Ranchwear Inc.

Looks like we cross posted. This is awesome! The only weird output I have now is: last updated: 10/25/05 Start date: 10/25/02 which should return a 3 is returning a 2.9 any ideas? Thanks!! Kenny Renaud IT Manager Corral West Ranchwear Inc.

Therefore the output I am getting is: 3.53456536618754, when it should be only 3.5 Thanks so much I am very grateful for all your help! Kenny Renaud IT Manager Corral West Ranchwear Inc.

This got me much closer to the correct out put, THANKS!!!! However the only issue I had, and it may be that I am running Access '97 in our office, is that Round wasn't recognized and the ,1 wasn't recognized. Kenny Renaud IT Manager Corral West Ranchwear Inc.

Thanks for the help guys. I need to know how many years and to the tenth for the next year. If I have the start date of 4/13/02 and the last update (the last time HR updated their db) of 10/25/05, the db needs to have a 3.5, for an output. Thanks Kenny Renaud IT Manager Corral West Ranchwear Inc.

I am working on a calculation where it is determined how long an employee has worked for our company. I don't want to use DateDiff function due to the fact I would like rounding to the nearest tenth. I have a [date hired] field and [last updated] field, and want the difference betweeen the...