Sumproduct in Access 2003

[izwan noor]

hai,

Currently i'm developing one database for my compay. I've two query.

A. Query A: 2 column = [Weight] and [ Age]
B. Query B: 1 column = [SumofWeight]

I would like to create one textbox that can give me the value of SUMPRODUCT
from (QueryA.Weight*QueryB.Age) and then divide with value from QueryB..

Currently i'm trying using Microsoft Excel 11.0 Object Library to run this
task. but i'm fail.

Can any one help me. Thank you in advance

- izwan -

 

[Stefan Hoffmann]

hi izwan,

A. Query A: 2 column = [Weight] and [ Age]
B. Query B: 1 column = [SumofWeight]

Depends query B on query A?

I would like to create one textbox that can give me the value of SUMPRODUCT
from (QueryA.Weight*QueryB.Age) and then divide with value from QueryB..

Create a new query:

SELECT [Age],
[Weight]
[Age]*[Weight]/DLookup("[SumOfWeight]", "QueryB")
FROM QueryA


mfG
--> stefan <--