Taking the string of a numeric field with decimals.

[Guest]

I have a field in my table that is numeric and includes decimals. The data
has either 3, 4 or 5 decimal places in each record... When I sum this field
it rounds up the data... I would like to either add this field without
rounding or just be able to use only 2 decimal places as opposed to 3, 4 or
5...

Any help in this matter would be greatly appreciated...!!!

 

[Ken Snell [MVP]]

Post examples of the data "as is", what happens when you sum the data (and
how are you summing them?), and what you want the result to be from those
"as is" data.

 

[Guest]

Eric
Have you tried changing the decimal place of that field in the table design
to 2?

 

[Joseph Meehan]

I have a field in my table that is numeric and includes decimals. The
data has either 3, 4 or 5 decimal places in each record... When I sum
this field it rounds up the data... I would like to either add this
field without rounding or just be able to use only 2 decimal places
as opposed to 3, 4 or
5...

Any help in this matter would be greatly appreciated...!!!

How about using currency as your data type?