Round function 1

[Jahappz]

i have this query in access that i want to round to 2 decimals


its a updatequery
that changes to this:
[D1154]/[forms]![menu]![euro]


is it something like this u should use?
round([D1154]/[forms]![menu]![euro],3)

or how??

 

[scriverb]

Check out this thread. There are two methods here available depending on rounding up needs.

thread701-861461

Post back if you need further assistance.

[COLOR=006633]Bob Scriver[/color]

[COLOR=white 006633]MSU Spartan[/color]

 

[amorous]

Two decimals...

round([D1154]/[forms]![menu]![euro],2)

-VJ

 

[Jahappz]

Two decimals...

round([D1154]/[forms]![menu]![euro],2)

this doesnt work it says missing opperand

any other ideas?

 

[Jahappz]

Isnt there someone that has done this ever????

2 decimals like 2.25 i get values like this now: 2.25464635634 and i only want 2 decimals....

Anyone`???

 

[PHV]

Have you tried this ?
Format([D1154]/[forms]![menu]![euro], "0.00")


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Jahappz]

yes it says illegal syntax and marks the ","

any idéas

 

[PHV]

Depending of your locale, you may consider replacing the comma (,) by a semi-colon (.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Jahappz]

WHoohoo! it worked! it was the comma when i replaced it with a semi-colon it worked like a charm!

Thank you PHV!