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 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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.