Decimal Places not working in query properties

[Guest]

I have a field that I am averaging but when I the settings I select in the
properties of the field are not passing to the query results.
Description...AveVolume
Format........General Number
Decimal Places...0

and I still get results like 16683799.6666667
So am I missing something or should I try formatting it in SQL? If I should
try and format in SQL can someone give me the syntax of using it?
the query follows.
********************************************
SELECT Count_Highs.[Symbol ] AS Expr1, Count_Highs.CountOfSymbol AS [Count],
Highs.[Company Name ], Last(Highs.[Last ]) AS LastOfLast, Highs.[Exch ],
Last(Highs.[Rel Str ]) AS [LastOfRel Str], Avg([Volume]) AS AveOfVolume,
Last(Highs.Date) AS LastOfDate
FROM Highs INNER JOIN Count_Highs ON Highs.[Symbol ] = Count_Highs.[Symbol ]
GROUP BY Count_Highs.[Symbol ], Count_Highs.CountOfSymbol, Highs.[Company
Name ], Highs.[Exch ]
HAVING (((Highs.[Company Name ]) Not Like "ishare*") AND ((Last(Highs.[Last
]))>9.99) AND ((Avg([Volume]))>100000) AND ((Last(Highs.Date))>Now()-30))
ORDER BY Count_Highs.CountOfSymbol DESC;
************************************************
Thanks,
RogueIT

 

[Guest]

Nevermind
In the field name I put
AveOfVolume: Format(Avg([Volume]),"#")
that seems to take care of it...
thanks anyway,
RogueIT

 

[Jeff L]

Make your data type Number and Field Size Long Integer.