[AccessD] complex query!!

On Wed, Jan 12, 2005 at 09:05:41PM +0100, Gustav Brock wrote:
> Hi Pedro
> 
> Bob is right but you need to Group By on the fields too:
> 
>   SELECT 
>     Avg(tblGroup1.FieldA+tblGroup2.FieldB)/2 AS Avg2
>   FROM 
>     tblGroup1,
>     tblGroup2
>   GROUP BY 
>     tblGroup1.FieldA,
>     tblGroup2.FieldB;

If that's what Pedro wants, then he doesn't need Avg(). 
	SELECT (tblGroup1.FieldA+tblGroup2.FieldB)/2 AS Avg2