[AccessD] complex query!! (solution)

Hi Gustav,

sorry, i will try to do my best to explain my questions as good as possible.
But sometimes that's not so easy.

Pedro


----- Original Message -----
From: "Gustav Brock" <Gustav at cactus.dk>
To: <accessd at databaseadvisors.com>
Sent: Saturday, January 22, 2005 11:09 AM
Subject: RE: [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 -
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>