Search results for query: *

Thank you for your reply. Your logic is exactly what I was considering. Figuring out the query for the middle days was where I was stumped. I will try this and see what I can do. Calculating uptime is fine, Thanks for yor help.

I need to be able to report downtime on our machines using a 16 hour clock; Ie: from 6am to 10pm. I have the data for the open and close dates of the calls. For instance if a call was opened on 8/15/03 at 4 am and closed on 8/20/03 at 9 pm the only downtime counted against it would be for the...

Thank you gentlemen for your replies. I'm sorry I should have stated I'm using version 8.5 and I have dl'ed all of the patches and hotfixes Seagate has. I have tried exporting to a csv and every other format that came to mind. It appears to be a problem with the calculations being done before...

I made up a report showing monthly Mean time To repair, MTBF, etc for our service organization. The conditional If Then Else statements cover the number of hours per month for my averages and the report is formatted and all is fine. However if I export it to Excel the conditional formula fields...

Thanks, SynapseVampire, I tried doing a subreport earlier but I don't know how to pull the totals of the install dtaes in the subreport back to my MTBF calcs in the main report. They need to be in the main report's formula.

I need to do Weekly and monthly Mean Time Between Failure calculations for our service organization. We use an Access 2000 based db and I pull the call dates, downtime hours , machine serial numbers etc. from various tables. It is easy to write a formula to give me MTBF values using the machines...