Hi,
I have a report that I am calculating Hours and Minutes for IT help desk time spent resolving various users problems. It is broken down by Department with calulcations per Dept and then a Grand Total Sum of Hours and Minutes at the end.
My problem - I calculate a revolving Sum based on...
HI,
We have ISA 2000 SP1 installed on a WIN2000 Server SP4.
We are using the ISA Server as a Mail Relay Server with our SPAM software on it to filter it before relaying to our MS Exchange Server.
Every so often (was once a week and now it is more common) we quit receiving email. I can check...
I have a field called "Write Down" and is a Dollar amount.
=([ORIG PRICE]*0.85)-([total cost])
The value above is how this Field is calculated.
How do I tell it to "only" Total the 'negative' values?
I do not any 'positive' values totaled for the Total Write Down...
Hello,
I have a Table consisting of only 3 Fields: Part Number, Cost Per Hour, Labor Rate(fixed at $45).
I want to build a Tabular Form that uses these fields and 2 or 3 other calculated fields on one row at a time.
I want to have the ability to "drop down" on the Part Number, have...
I have a Query that lists Hours and Truck Number.
In a Report I calculate the Grand Total of Hours for All Truck Numbers.
How do I go about performing a Sub Query that calculates total Hours for ONLY Truck Number "Z000"?
Table Name is:
Activity Table
Here is the Code for the Query...
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.