Expression in a report

[Guest_imported]

Hello and thanks in advance, I am converting some access reports to asp to display them on the web and would appreciate it if someone could tell what the following expressions on the access reports do exactly.<br><br>=1-RoundCC(([txtNYPALevel]/[txtTotalHalfDemand]))<br><br>=roundtwo([txtP2Energy]*[txtOnPkUseRate])<br><br>I do not what the RoundCC and Roundtwo mean, is it converting the result to 2 decimal places in the second exp. and what about the first? <br><br>

 

[advpay]

you sure it works they seem to be undefined functions...can you give us anymore information...like the tables that the fields are in and Data Types.

 

[Guest_imported]

they do work. The fields are basically being retrieved from a uqery and the datatypes of these fields are numbers. DO you hting they are just simple rounding functions, like roundtwo rounds the result to two decimals, I do not know what RoundCC stands for though?

 

[advpay]

I don't think they round...I tried them both as functions in Access 2000, they are not allowed functions, don't know about earlier versions...as far as I can tell from what you have give me for fields and looking at your expressions...RoundCC is a supplied variable not a function. It seems as you are rounding the division and multiplication of the individual expressions and subtracting the first on from 1 to get a percent to use and simply rounding the other.