[AccessD] complex query!! (solution)

Scott,

Oooh! Good one. I think that'll do it, as long as the Keys are nice
and sequential.

Steve Erbach


On Fri, 21 Jan 2005 15:39:42 -0500, Scott Marcus <marcus at tsstech.com> wrote:
> 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
>