Using Cutom Functions in a Query (form recordset)

[Salty Mariner]

I'm not sure what you mean, I added up the distance with a calculator and got a 0.1 difference. I used the Round Function on the decimals in the total distance summary so that might account for the 0.1 nm difference.



What are you seeing that I am not? Thanks for noticing what ever it is that you are seeing. I'm certainly not perfect so If there is an error I would want to find it.

[Welshgasman]

Yes, there appears to be rounding errors.
Add them up, and I get 119.1 and 11:17

That is why I was asking if it that would cause you any issue?
You should not get any difference with the time though, I would have thought?

[Salty Mariner]

Yes, there appears to be rounding errors.
Add them up, and I get 119.1 and 11:17

That is why I was asking if it that would cause you any issue?
You should not get any difference with the time though, I would have thought?

Time is a derivative of distance / speed so yes there is a direct relationship.