Round function in A97

[barbarossaii]

Hi,

how can I round the result of a calculation in A97 ?
There seems to be no round-funktion in my German A97, so

ppm: ROUND(1000000*[s_schl]/[s_gel];0)


doesn't work in the design view of a query; instead I only get an error
message "undefined function 'ROUND' in expression".



Thanks in Advance,
Barbarossa II

 

[dcx693]

See this thread: Rounding to the nearest million

 

[barbarossaii]

Thanx dcx693,

do you know if there is a difference between the "Int-method" and the round-function of newer access-versions (run-time, accuracy,...) ?
Or is the round-function just more user friendly and using the "Int-method" internally ?

TIA,
Barbarossa II

 

[dcx693]

It's almost always better to use a built-in function rather than recreating the funtionality using other functions. When the functions are pre-compiled and part of the program "executable" itself, they run VERY fast. John Walkenbach, author of several books on Excel has run speed tests to prove this.