Acess VBA code

I am using Access 2000:

Is there a way to have some code search through a table computing the average of certain fields? I need to be able to do it at run time and from my main form.

How do I get access to the entries in a table in VBA code?

Thanks a lot!!!!

Andrew

Can you use SQL
Select AVG(Field) as A from Table

Iouri Boutchkine
[email protected]