Access 2003 calculated fields and decimal places

[Guest]

i am trying to create a calculated field in a form but even though i have set
decimal places to 0 in properties it still uses 2 decimal places please can
someone tell me where i am going wrong.

my formular is =([base]-[Entry Average])*[percentage]

i need to be able to round the result down to the nearest whole number

 

[Allen Browne]

Use the Round() function (Access 2000 and later) if you want to round to the
nearest number, or the Int() function if you want to round down.

Example:
=Int([base]-[Entry Average])*[percentage])

 

[Guest]

didnt work

Use the Round() function (Access 2000 and later) if you want to round to the
nearest number, or the Int() function if you want to round down.

Example:
=Int([base]-[Entry Average])*[percentage])

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

i am trying to create a calculated field in a form but even though i have
set
decimal places to 0 in properties it still uses 2 decimal places please
can
someone tell me where i am going wrong.

my formular is =([base]-[Entry Average])*[percentage]

i need to be able to round the result down to the nearest whole number

 

[Guest]

sussed it was missing a (at start of formula thaks for info am now sorted

Use the Round() function (Access 2000 and later) if you want to round to the
nearest number, or the Int() function if you want to round down.

Example:
=Int([base]-[Entry Average])*[percentage])

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

i am trying to create a calculated field in a form but even though i have
set
decimal places to 0 in properties it still uses 2 decimal places please
can
someone tell me where i am going wrong.

my formular is =([base]-[Entry Average])*[percentage]

i need to be able to round the result down to the nearest whole number