Finding a Percent Query

[pickslides]

Hi all,

I have posted my database , I want Query 1 to have an extra field for % of Avg car sales by Make

At the moment I have


[CODE][SELECT Sales.Make, Avg(Sales.Price) AS AvgOfPrice
FROM Sales
WHERE (((Sales.SalesMonth)="November" Or (Sales.SalesMonth)="December"))
GROUP BY Sales.Make;
/CODE]

Q

[alansidman]

Try this:

SELECT Query1.Make, Query1.AvgOfPrice, DSum("AvgOfPrice","Query1") AS PC, [AvgOfPrice]/[PC] AS [Percent]
FROM Query1
GROUP BY Query1.Make, Query1.AvgOfPrice;