On May 19, 9:54*pm, John Spencer wrote:
SELECT AreaElem, Joint, GlobalX
,Avg(GlobalY) as AvgY
,Avg(M_sd) as AvgM
FROM YourTable
GROUP BY AreaElem, Joint, GlobalX

In query design view
== Add your table
== Add the five fields
== Select View: Totals from the menu
== Change GROUP BY to Avg under GlobalY and M_sd

I've tried to follow your suggestion but I wasn't able to make my
query return a condensed version of the original table. Unfortunately
it still returns 4 joints per node. Could you please take a look at
my SQL to try to see what I'm doing wrong?

The SQL is as follows:
sql
SELECT [Objects And Elements - Joints Consulta].AreaElem, [Objects And
Elements - Joints Consulta].Joint, [Objects And Elements - Joints
Consulta].GlobalX, Avg([GlobalY]) AS AvglY, Avg([M_sd]) AS AvgM
FROM [Objects And Elements - Joints Consulta]
GROUP BY AreaElem, Joint, GlobalX
/sql


Thanks for the help,
Rui Maciel