Undefined function 'Rounddown' in expression

[Tezdread]

Hi all,

I have a couple of queries where I need to round down the numbers. I thought I could use the Rounddown function but thisthrows up an error.

(Undefined function 'Rounddown' in expression)

Does anyone know why this error would occur (and more importantly how to get around it?) this is the query

MaxRounded: Rounddown([MaxDivided]-2,0)

I have a couple of queries and need to apply the Rounding down to all of them, they all divide one number with another.

i.e. /3 & /1.85

These are a few of the numbers calculated

6666.66666666667 - Should be 6,600

10810.810810810810810810810811 - Should be 10,800
7297.2972972972972972972972973 - Should be 7,200

 

[KenHigg]

Where did you come up with rounddown()?

 

[Tezdread]

'Microsoft Access Help' (this is the info)
------------------------------------------------
ROUNDDOWN
Rounds a number down, toward 0 (zero).

If this function returns the #NAME? error value, you may need to install msowcf.dll.

Syntax

ROUNDDOWN(number,num_digits)

Number is any real number that you want rounded down.

Num_digits is the number of digits you want to round to. Negative rounds to the left of the decimal point; 0 (zero) or omitted rounds to the nearest integer.
----------------------------------------------------------

This was also found on this forum:

http://www.access-programmers.co.uk/forums/showthread.php?t=52107&highlight=rounddown
----------------------------------------------------------

I've checked for the msowcf.dll file and that's there (c:\program files\microsoft office\office\)

 

[KenHigg]

Appears as though rounddown() is an excel function. I think you have to check the excel objects in references to get it to work...

 

[maxmangion]

Why don't you use the Round() Function ?

Then you can use the Format() Function to get your desired formatting.

 

[Tezdread]

thanks guys,

after trying the Round option it doesn't seem to give me the disired results.

e.g. MaxRounded: Round([MaxDivided]-0) (If I add a number to the end other than zero, all the rounded numbers become incorrect)

20000 /3 = 6666.6666667 after Rouding and Formatting = 6,667.00 (should be 6,600 or even 6,600.00)

10500 /3 = 3500 after Rouding and Formatting = 3,500.00 (this is ok)

Am I missing something? If not is there another way of getting a rouded number that gives the desired results?

 

[Tezdread]

sorted...

MaxLimit = 20000
MaxDivided: ([MaxLimit]/3) = 6666.66666666667
MaxRound: Int(([MaxDivided]/100))*100 = 6600