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

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

To correct the previous thread, syntactically it should have read

Round([A]*[B],2)

Note it is a comma, not a semi colon.

CodeMaster::cool:

To correct the previous thread, syntactically it should have read

Round([A]*[b],2)

Note it is a comma, not a semi colon.

CodeMaster::cool:
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.

Very, very rare I use bound forms but

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

Seems syntactically incorrect Ronund - should this be Round:confused:

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:eek:

CodeMaster::cool:

Very, very rare I use bound forms but

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

Seems syntactically incorrect Ronund - should this be Round:confused:

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:eek:

See attachment

When I used my syntax no errors:)

CodeMaster::cool:

Thanks,

I will try it.

Daniel