I am having a lot of trouble trying to get floating points values correct. My numbers are to the third decimal point. Some come out correct and while others do not. I've tested them in Excel and it comes out correctly but not when doing calcs within Access. For example, I should get a value of 744.744 but instead I get 744.740. Very frustrating. I need to have the 3rd decimal showing the correct value.
I would appreciate if someone provided me why this is happening and how to fix it.