I've attached the form that I'm working with so that you can see what I'm going through and hopefully tell me that it's a simple fix.
My form pulls in a formula from tbl_Formulas to a tmp_Formula table to work with. From there the user inputs all kinds of information and updates it. One of those pieces of information is the [Claim]. Once they update that and click update formula (button removed from testingarea.accdb, please manually save/refresh form) and qry "1" runs to update the [DV] field. "1" is an update query that should update [DV] to = [Claim]/[ADV].
[ADV] is a field from tbl_RawMaterial. In Query "1" I have tbl_RawMaterial.RawMaterial= tmp_Formula.RawMaterial. So I believe the numbers are being pulled correctly. The problem is this: If you place "12.5" in the claim of the first ingredient listed (which is 101114 - RIBOFLAVIN USP), run "1" and refresh the form, you get 10.00 as the [DV]. This should be [Claim]/[ADV] = 12.5/1.3 = 9.61
I'm driving myself mad trying to figure out how/why it's rounding. I've checked the formatting of [Claim], [DV], [ADV], qry field settings, tbl field settings, nothing is adding up.