Query Issue

[access]

Hi,



I have a table
Table1 Table2 Table3
IndN AggN CompN
23 10 (23*12*76*44)/10
12
76
44

I would like to write a query to read the values from Table1 and Table2 and store the result with one row in Table3 as above using query:

SELECT Sum(IndN)/AggN as CompN INTO Table3 FROM Table1, Table2;

But i'm getting the following error:
"You tried to execute a query that does not include the specified expression Sum(IndN)/ as part of an aggregate function."

I'm not sure whether access supports this kind of query. Is there any other way to do this, Other than writing in two separate queries. Can any one please let me know. Thanks in advance.

[llkhoutx]

A query will not do the calculations you want. remember queries peform caluclate within rows.

You can peform you calculation in VBA code using DAO/AD recordsets.