Format

[Dannyboy11]

I run a query and it returns a number. How can I make it so the number is only shown to 2 decimal places?

 

[vbaInet]

Here's how:

http://www.techonthenet.com/access/functions/numeric/format.php

 

[Dannyboy11]

I did what the web site said and it went to

League Mark: Avg(Format([Mark],"#,##0.00"))

Now when I open the form the average is coming up as 39.444444444

 

[G81]

I did what the web site said and it went to

League Mark: Avg(Format([Mark],"#,##0.00"))

Now when I open the form the average is coming up as 39.444444444

Probably because you are working out the average from the [mark] field and you haven't specified the format afterwards. i.e. the average of 0.44,0.43,0.44 is 0.4366666666666

If you done Format(Avg([Mark]),"#,##0.00")

it would do the 2 decimal places after working out the average.

 

[Dannyboy11]

Oh ok. So what would it be to do the average to two decimal places?

 

[G81]

I put it in the answer above.

If you done Format(Avg([Mark]),"#,##0.00")

it would do the 2 decimal places after working out the average.

 

[Dannyboy11]

Ah yes. I thought you meant something else.

Thank you