I hate to ask this question because I think it will be easy to answer but I have searched forums and used google and cant find an answer.

Is it possible to display an SQL querie to a text box or a label caption? - in particular I want to display the results of Sum or Average (which should be a single word answer

eg if I have a table called wind, and 2 columns (date and wind strength) and I want to find the average wind per month I can use the statement

SELECT Average(wind strength) FROM Wind WHERE date = 'Jan'

but how do I tell it to display the result in a text box?

thanks