Problem with Rounding

[mosh]

Hi All,

I have the following text box that calculates an average, but it gives a 10 decimal place number;
="Average Orders" & " : " & DAvg("[CountofOrder_id]","[qryRegCust]")

Can anyone please help with the Round function?

Thanks
________
CYNTHYAXX LIVE

 

[pbaldy]

What part of it are you having trouble with? Just put the DAvg in the first argument of the Round function.

 

[mosh]

What part of it are you having trouble with? Just put the DAvg in the first argument of the Round function.

it doesn't work,

I've tried;

round(DAvg...
________
party Cam

 

[pbaldy]

I just tested and it worked as expected:

?davg("amount","charges")
122.73062972012438916037316748
?round(davg("amount","charges"),2)
122.73

 

[mosh]

thanks for your help guys, found that I was putting the ",2" in the wrong place.

Thanks.
________
Harriet