Calculation on Unrelated Tables

[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

 

[Duane Hookom]

Could you take the time to type a few sample records into a reply as well as
the desired calculation and result?

 

[LMB]

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

 

[Duane Hookom]

You can combine two tables or queries and not join them.

 

[LMB]

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

Thanks a lot!

 

[Duane Hookom]

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.