Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. AccessRookie

    MS Access "Hours" Calculation Help Needed

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

    ISA Service Problem

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

    Field Total Question

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

    One Table Form Problem

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

    Sub Query Help

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

Part and Inventory Search

Back
Top