Getting avgerage in Access Query

[cegbuna]

I am having troubles calculating Averages using Access Query. Here is what am trying to do.

<table style="width: 210px; height: 136px;" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="width:48pt" width="64" span="2"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;width:48pt" width="64" height="20">Name</td> <td class="xl63" style="border-left:none;width:48pt" width="64">Data</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" height="20">Name 1</td> <td class="xl63" style="border-top:none;border-left:none">Num 1</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" height="20">Name 1</td> <td class="xl63" style="border-top:none;border-left:none">Num 2</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" height="20">Name 1</td> <td class="xl63" style="border-top:none;border-left:none">Num 3</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" height="20">Name 1</td> <td class="xl63" style="border-top:none;border-left:none">Num 4</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl63" style="height:15.0pt;border-top:none" height="20">Average =</td> <td class="xl64" style="border-top:none;border-left:none"> ?</td> </tr> </tbody></table>
How do I create a query to calculate the average of Num 1 to Num 4 and have the result inserted in a column?

As always, thanks for the help

 

[Joe4]

Take a look at Aggregate (Totals) Queries in Access's built-in help files. You will want to group it by Name, and take the average of the Data field (Average is one of the options for the Aggregate function).

 

[cegbuna]

Thanks!!!