Taking the string of a numeric field with decimals.

E

EricB

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...!!!
 
K

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.
 
N

Natalie

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge - displaying a conditional number of decimals 5
Stop Rounding in Forms 2
Form Combo incorrectly rounding 1
Page numbering with Merged Document and IF statements 1
Converting decimal degrees to degrees, minutes & seconds 2
Finding the right style field in VBA 0
Decimal places in charts 4
0 Decimal places/round function. 4

Top