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 -

hi izwan,

izwan noor wrote:
> 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 <--