Using totals in formulas in a query

[dougie]

I have a query that groups data and produces two totals for each group. A second query takes this first query as its input and divides one total by the other for each group. Is it possible to do this in one step?

[JoeM]

If you swtich to SQL view, you can see the SQL code behind each query. If you "nest" the code from the first query inside of the second query, then you will have it all in one query. Note that you will probably need to do this in SQL view.

[RayMilhon]

Yes, in the totals line of the query where it says group by change it to expression. Then in the Field use "Column name:Sum([fieldA])/sum([fieldb])"

[dougie]

RayMilhon:

Yes, I eventually figured it out.