[AccessD] complex query!!

Pedro,

Do you have 7 tables, one for each group?

Steve Erbach
Neenah, WI

> ------------Original Message------------
> From: Pedro Janssen <pedro at plex.nl>
> To: AccessD at databaseadvisors.com
> Date: Wed, Jan-12-2005 7:07 AM
> Subject: [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 -