Updating Records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all,

As usual thank you so very much for your help. Question: I have a few
calculated fields. They are all currency format (numbers). I have an update
query enter them into the table. Problem: The values to the left of the
decimal are rounding up.

Example: 143.54 is 144.00. Regardless of the value. I made the fields text
but then the value is like 143.5333992 and I cannot figure it out. Any ideas?

Thanks,

Raymond III
 
The table you are writing the values into: open it in design view.
Select the field that is wrongly rounding up.
Change the Data Type column from Number to Currency.

Explanation: You will see that the Field Size (in the lower pane of table
design) was set to Long Integer. The integer types handle whole numbers
only. The Double can handle fractional numbers, but currency is better. (It
is a fixed point type, and does not have the problems of floating point
types.)
 
I sincerely appreciate you helping me out with that! I also appreciate the
further education on what the other represent. Hilarious I dabble in visual
basic me.value. this and IF statements but I didn't read what the simple
things represent.
 
Back
Top