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