[AccessD] complex query!! (solution)

Hi Marcus

That's how, of course. I didn't read the question carefully enough.
Pedro, if this is not what you request you need to explain it a bit
further.

/gustav

>>> marcus at tsstech.com 21-01-2005 21:39:42 >>>
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 -