vba query question

[jscriptor09]

Hi folks

Would like to know how if it is possible to combine 2 queries into one.

TableA
SaleDate Model1 Model2 Model2
1/1/2011 1 0 5
1/1/2011 5 1 0
1/2/2011 2 4 1
1/3/2011 0 1 1


1/3/2011 4 1 2
1/3/2011 5 0 4
1/3/2011 6 1 4

I have a simple query to sum how many sold per day
I have a simple query to do %model sold: %model2 = #Model2/(#Model1+#Model2+#Model3)

I take care of division by zero issues.

Question:
is it possible to combine the sum query with the calc % query into one? Sort of how do I get the sum done first in a vba sql query and then followed by the %calc query?

Thanks for your help

[June7]

Assume you are using a Group By totals query. Try:

PctModel2: Count(Model2)/(Count(Model1)+Count(Model2)+Count(Model3))

Select 'Expression' in the Total row of the query designer.

Avoid special characters and punctuation in names.

[jscriptor09]

Hi June7

Many thanks for the help. This solves the issue. I appreciate your help.

Any idea how to mark this as solved?

Mike