Is there any standard way of "Ronding off" currency fields?

[Mattias]

Hi

Using Access XP and have alot of currency fields that are involved in %
caluclations etc. Unfortunatly I found some errors due to this.

Is there any easy standard way of telling the whole database to round off
every currency field a certain way...

Please help

Mattias

 

[Rhonda Floyd]

Look at this function, it recently helped me.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;97524

I hope it helps.
Rhonda

Hi

Using Access XP and have alot of currency fields that are involved in %
caluclations etc. Unfortunatly I found some errors due to this.

Is there any easy standard way of telling the whole database to round off
every currency field a certain way...

Please help

Mattias

 

[Mattias]

Thank you very much...I will try it!

Mattias
Look at this function, it recently helped me.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;97524

I hope it helps.
Rhonda

Hi

Using Access XP and have alot of currency fields that are involved in %
caluclations etc. Unfortunatly I found some errors due to this.

Is there any easy standard way of telling the whole database to round off
every currency field a certain way...

Please help

Mattias