Rounding

[DKnight via AccessMonster.com]

I have an expression in access that is rounding up. I don't want any
rounding. I want to see the exact calculation. How do I do this?

 

[Jeff Boyce]

By "rounding" do you mean you are entering something like "17.3" but getting
only "17"? If so, re-check the data type in the table ... that could happen
if the data type is set to integer (whole numbers only).

You said "an expression". Please post the expression.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[DKnight via AccessMonster.com]

my expression is [number of poles] * [pole charge]. Both fields are
described as 'single, fixed , 2 decimals. When I multiply the pole charge(.
50) By the number of poles (1). It rounds up to 1. or if is the pole charge
is 1.50 and number of poles is 1, it round up to 2.

 

[Jeff Boyce]

Thanks for posting the expression.

I can't tell where this is being used, but I'll assume it is in a query, a
form or a report. Have you confirmed that the (query's, form's, report's)
field is not set to INTEGER?

Regards

Jeff Boyce
Microsoft Office/Access MVP

my expression is [number of poles] * [pole charge]. Both fields are
described as 'single, fixed , 2 decimals. When I multiply the pole
charge(.
50) By the number of poles (1). It rounds up to 1. or if is the pole
charge
is 1.50 and number of poles is 1, it round up to 2.

By "rounding" do you mean you are entering something like "17.3" but
getting
only "17"? If so, re-check the data type in the table ... that could
happen
if the data type is set to integer (whole numbers only).

You said "an expression". Please post the expression.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[DKnight via AccessMonster.com]

It is in a form. I have the format of the textbox set to fixed, 2 decimals

Thanks for posting the expression.

I can't tell where this is being used, but I'll assume it is in a query, a
form or a report. Have you confirmed that the (query's, form's, report's)
field is not set to INTEGER?

Regards

Jeff Boyce
Microsoft Office/Access MVP

my expression is [number of poles] * [pole charge]. Both fields are
described as 'single, fixed , 2 decimals. When I multiply the pole

[quoted text clipped - 18 lines]

 

[Jeff Boyce]

Hmmm... that exhausts my ideas...

Maybe one of the other newsgroup readers has run across something like
this...

Regards

Jeff Boyce
Microsoft Office/Access MVP

It is in a form. I have the format of the textbox set to fixed, 2
decimals

Thanks for posting the expression.

I can't tell where this is being used, but I'll assume it is in a query, a
form or a report. Have you confirmed that the (query's, form's, report's)
field is not set to INTEGER?

Regards

Jeff Boyce
Microsoft Office/Access MVP

my expression is [number of poles] * [pole charge]. Both fields are
described as 'single, fixed , 2 decimals. When I multiply the pole

[quoted text clipped - 18 lines]

I have an expression in access that is rounding up. I don't want any
rounding. I want to see the exact calculation. How do I do this?