[AccessD] complex query!!

Pedro Janssen pedro at plex.nl
Wed Jan 12 09:52:11 CST 2005


Hello Steve,

yes i have 7 tables, one for each group.

- Pedro -

----- Original Message -----
From: "Steven W. Erbach" <serbach at new.rr.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Wednesday, January 12, 2005 2:53 PM
Subject: Re: [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 -
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>





More information about the AccessD mailing list