I have a three fields in my Transactions Table. I want to keep track of the vehicle mileage. I have a Start Miles, End Miles and Total Miles. I want to add the total miles by week, but when i perform that function it gives me an error message,"That the operation is to complex for the function". I get this message when i try to sum the total miles.

---

Reply from Richard Rost:

Well, how are you performing the calculation? Can't help to fix it if I can't see what you're doing. :)