field type... get avg() ...of an access text field

[TRYP]

i have an access DB that has a text column of "integers" how can i use the avg function or average them with out individually convertiong the values??? any ideas [sig][/sig]

 

[mvanbro]

select avg(fieldname) from tablename

or do I misunderstand the dilema


[sig][/sig]

 

[TRYP]

mva...

all the text is whole numbers, but the data type is text.
(string)
i want to get avg() of the columns but i want to avoid having to select the columns and loop through them to convert them using cint() any ideas?
tryp [sig][/sig]

 

[MichaelRed]

???

select avg(cint(fieldname)) from tablename

???

[sig]<p>MichaelRed<br><a href=mailto:mred@duvallgroup.com>mred@duvallgroup.com</a><br>There is never time to do it right but there is always time to do it over[/sig]

 

[TRYP]

tried the cint() inside of avg() no go but i did find the answer avg(val(fieldName)) !

Thanks all. [sig][/sig]