Average format

[Guest]

Hi all,

I am trying to make a field in a select query formatted to a whole number
while using group by AVG. Someone suggested yesterday I use - Format
([fieldname],""##,##0"). The format works fine except for when I change the
group by function to "AVG". Any ideas?


Bruce DiPaola

 

[John Vinson]

Hi all,

I am trying to make a field in a select query formatted to a whole number
while using group by AVG. Someone suggested yesterday I use - Format
([fieldname],""##,##0"). The format works fine except for when I change the
group by function to "AVG". Any ideas?

You'll need to do the Avg() inside the Format function - Format
returns a text string, and you can't average that!

Try

Format(Avg([Fieldname]), "#,##0"))

If that's not working please post the complete SQL view of your query.

John W. Vinson[MVP]