Search results for query: *

Thanks for the replies - Paul in regards to your question, I am campturing Hours in one field and Minutes in another. When I total them on the same report, if minutes are under 60 - it adds an hour to the hour field in the report.

Anyone have any other suggestions?

The formula I am using for Hours: =Sum(([Hours])+([Minutes])/60) But the problem is any minutes under 60 get calculated as 1 hour. It is rounding I guess.

but if you can't do that, then why not just sum the minutes, and then use that to calculate the hours + mins seperately..." That is what I currently have, but when you add your hours and (minutes/60) - if the minutes total is under 60 minutes it rounds up as 1 - and thus adds an incorrect Hour...

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

Thank You Very Much Duane! It's simple things like the ABS formula that makes it so much easier! Thank you!!

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

Hmm, okay, I am not sure how to make what I am after then. I was hoping to have a FORM in which I select the Part Number from a Drop Down box, then the cost automaticaly pops in for the second field, and the 3rd field is the foxed labor rate field, Field 4 and 5 would be calculated. All of...

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

This is Perfect! Thank You soooooo much for your expert help! I could never figure out how to Run a Query within a Query and this is perfect!

Thank You for the Help! But.... I copied this code (added two closing parenthesis at the end) and placed it in the heading of a blank field and pressed Enter. It took it as EXPR1, which is okay so far. Then I run my Query and it says the following error: "You have written a subquery...

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