[AccessD] complex query!!

Hello group,

for a statistic analyses of DNA-samples i need to compare each sample from a group with eachother sample from another group. I have 7 groups with up to 17 samples. Let me explain what i need in an example. 

I have

Two tables group1 and group2, with each two records.


i need the average of:
group1_record1 + group2_record1
group1_record2 + group2_record1
group1_record1 + group2_record2
group1_record2 + group2_record2


and this for 7 groups up to 17 records


Is this possible in a query per 2 groups, 
or can this been done in total by code?

- Pedro Janssen -