problem with average and decimal places

[weezles]

hi

I am using the following in a SELECT query to try and round to 1 decimal place.

Avg(Round([SocFun],1))

However, it is not working. I have also tried using the properties of the query and the properties of the text field in the report. Nothing seems to work.

Any ideas

Ta

Lou

 

[smedvid]

Don't u want to switch these?
Round(Avg([SocFun],1))

Perhaps I don't see the issue? any data examples..

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[weezles]

Hi

After spending ages pulling my hair out over this, i post a message then fix it.

I have set format to Fixed and decimal places to 1. I have had to do this on both the report and query but it works.

Thanks

Lou