Access 2003 calculated fields and decimal places

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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])
 
didnt work

Allen Browne said:
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.

daveyboy300 said:
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
Click to expand...
Click to expand...
 
sussed it was missing a (at start of formula thaks for info am now sorted

Allen Browne said:
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.

daveyboy300 said:
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
Click to expand...
Click to expand...
 
Back
Top