Scott Marcus
marcus at tsstech.com
Fri Jan 21 14:39:42 CST 2005
The answer is the following, where id is the primary key of Table1...
SELECT ([a].[factor]+[b].[factor])/2 AS Average_OF_Factor,
a.factor,
b.factor
FROM Table1 AS a,
Table1 AS b
WHERE [a].[id]<[b].[id];
Scott Marcus
TSS Technologies, Inc.
marcus at tsstech.com
(513) 772-7000
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Pedro Janssen
Sent: Thursday, January 20, 2005 4:52 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] complex query!!
Dear Steve and Others,
nice that you all are talking about age and children. I am not that old,
only 40 year. I also have a son and he is 4 years old. All nice, but i
won't
puss you, but have you thought about my original question??
I also have a new one, that's also important. I need a Cartesian query
of a
table with one field.
And need each average of pears of records , but not with itself
I have:
Table1
fieldA
1
2
3
4
I need Average of:
1 vs 2
1 vs 3
1 vs 4
2 vs 3
2 vs 4
3 vs 4
I'll hope that this is easy.
- Pedro Janssen -
----- Original Message -----
From: "Steve Erbach" <erbachs at gmail.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Thursday, January 20, 2005 1:36 PM
Subject: Re: [AccessD] complex query!!
> Jim,
>
> She gets the dimple on the right side, her pointed ears, and the
> distance between the eyes from me. My mother's side of my family
> provided the tiny nose. Otherwise it's all Janet, my wife. Every day I
> tell Eleanor that she is the most beautiful girl that has ever been
> born in all of recorded human history.
>
> Now, what was the topic supposed to be again?
>
> Steve Erbach
> Neenah, WI
>
>
> On Wed, 19 Jan 2005 18:43:04 -0800, Jim Lawrence <accessd at shaw.ca>
wrote:
> > Hi Steve:
> >
> > She sure is cute! Does she get her good looks from her Mom? ...or
from
Dad?
> >
> > Jim
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com