Calculation on Unrelated Tables

  • Thread starter Thread starter LMB
  • Start date Start date
L

LMB

Can you do a calculation using a number from 2 unrelated tables or do I need
to relate them to eventually make a calculation?

Thanks,
Linda
 
Could you take the time to type a few sample records into a reply as well as
the desired calculation and result?
 
Well....LOL I haven't gotten that far yet, I was just wondering <g> I am
planning on my queries to give me an average number based on a month of data
from 2 different tables that do not have any fields in common. The averages
will be an expression from 2 numerical fields in the 2 different tables.

So let's say my average number from table 1 for the 31 days is 3.3

The Average number from my other table 2 for 31 days is 19.2

This is the calculation in excel that give us the number we want from these
2 numbers.

=(19.2*3.3)*31



Linda
 
Ok...I figured it could be done.. Next the question will be how to do it
when I get that far!

Thanks a lot!
 
Just create a query and add one or more tables or queries to its data
source. Keep in mind that if you add two tables/queries without joins, your
results may be not what you expect:
Records In A Records In B Total in Query
1 10 10
10 1 10
10 10 100
Of course we don't know what you expect.
 
Back
Top