Problem with rounding numbers

[Danielf]

Hi,

I am multiplying Field "A" (2 decimal number) by Field "B" ( 4 decimal number) . The result is field "C" ( of course sometimes a 4 decimal number);

Even if I use the function Round ("C",2), Access still stores "C" as a 4 decimal number. I have tried in my table to format "C" as a Fixed 2 decimal number but when I am clicking on it, it still gives a 4 decimal number.

Any idea how to resolve this?

Thanks

Daniel

 

[MStef]

Try this, In field C Control Source properties put;
=Ronund(([A] * );2)

 

[DCrake]

Simple Software Solutions

To correct the previous thread, syntactically it should have read

Round([A]*,2)

Note it is a comma, not a semi colon.

CodeMaster:

 

[ErikSnoek]

To correct the previous thread, syntactically it should have read

Round([A]*,2)

Note it is a comma, not a semi colon.

CodeMaster:

Actually, it should be a semi-colon like MStef said. In VBA code it's a comma but MStef told OP to put it in the Control Source property.

 

[DCrake]

Simple Software Solutions

Very, very rare I use bound forms but

=Ronund(([A] * );2)

Seems syntactically incorrect Ronund - should this be Round

The use of BoDMaS in this example is not needed

And when tried my self on a makeshift test the semi colon raised an error

CodeMaster:

 

[DCrake]

Simple Software Solutions

Very, very rare I use bound forms but

=Ronund(([A] * );2)

Seems syntactically incorrect Ronund - should this be Round

The use of BoDMaS in this example is not needed

And when tried my self on a makeshift test the semi colon raised an error

See attachment

When I used my syntax no errors

CodeMaster:

 

[Danielf]

Thanks,

I will try it.

Daniel