Hi,
I want to create a query from 2 calculated queries.
Query1 contains several rows
yearNo 'year part of the date of birth
numBirths 'number of births for that year
logNumBirths ' natural log of numBirths
Query2 (from Query1) contains 1 row
n: Count(*) 'count number of records in Query1
sumX:Sum([YearNo]) 'sum of all years in Query1
Mx:[sumX]/[n] 'sum of years/number of years
sumY:Sum([logNumBirths]) 'natural log of sum of all years
My: [sumY]/[n] 'sum of natural log of years/number of years
I want to create a query that uses data from both queries:
Txx = ([YearNo1]- [Mx])^2 + [YearNo2]- [Mx])^2...[YearNo_n]- [Mx])^2)
Basically, for each row of Query1, I want to use data from Query2. Or is there another method I can use?
Any help would be appreciated.
Thanks,john
I want to create a query from 2 calculated queries.
Query1 contains several rows
yearNo 'year part of the date of birth
numBirths 'number of births for that year
logNumBirths ' natural log of numBirths
Query2 (from Query1) contains 1 row
n: Count(*) 'count number of records in Query1
sumX:Sum([YearNo]) 'sum of all years in Query1
Mx:[sumX]/[n] 'sum of years/number of years
sumY:Sum([logNumBirths]) 'natural log of sum of all years
My: [sumY]/[n] 'sum of natural log of years/number of years
I want to create a query that uses data from both queries:
Txx = ([YearNo1]- [Mx])^2 + [YearNo2]- [Mx])^2...[YearNo_n]- [Mx])^2)
Basically, for each row of Query1, I want to use data from Query2. Or is there another method I can use?
Any help would be appreciated.
Thanks,john