Having a bit of trouble once again. I have a few fields that I am querying and three of them have to do with time. Two fields are the start times and end times of an error that is being logged. The thrid column is a sum between the two start and end times. I need to calculate a sum of the entire third column or Downtime column. Any help is greatly appreciated! I would like to try to keep this in an expression form due to my lack of knowledge with Basic. Oh yeah, I tried to use the sum feature, but the time is not recording right due its format being in Date/Time format. For somo odd reason it is giving me long numbers with exponents when I use the Sum function in my Query. I hope this makes sense. Thanks folks..
Query to Sum entire downtime!
- Thread starter robk5787
- Start date
