Subquery Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to get this result using one select query. The ProdTtl field is
the sum of ProdAmt within each Function.

Function Prod ProdAmt ProdTtl
1010 100 7,782.36 279,559.20
1010 110 136,448.37 279,559.20
1010 315 126,519.59 279,559.20
1010 345 8,808.88 279,559.20
1045 100 36,480.91 96,222.96
1045 110 1,506.30 96,222.96
1045 300 43,330.25 96,222.96
1045 325 14,905.50 96,222.96

I'm playing around with subqueries, but thus far haven't come up with
anything that works. Help!
 
Put this in one of your query fields:
Format(DSum("ProdAmt","YourTableName","Function = " &
[Function]),"Currency")

Hope that helps!
 
Back
Top