N
nazzoli
I have two queries that i need to utilize to somehow create an expression.
1st Query houses this data:
Month SumofBal
1 1000
2 2000
3 4000
4 5000
all the way up to month 12....(sumofBal will vary)
2nd Query houses this data
Month SumofPaid
1 100
2 100
3 100
again this goes all the way up to month 12...(sumofpaid will vary)
What I am looking to create is a new query that will go something like this:
Month Percentage
1 [sumofpaid] for month 1/sum[sum of bal] for months 1-12
2 [sumofpaid] for month 2/sum[sum of bal] for months 1-11
3 [sumofpaid] for month 3/sum[sum of bal] for months 1-10
4 [sumofpaid] for month 4/sum[sum of bal] for months 1-9
1st Query houses this data:
Month SumofBal
1 1000
2 2000
3 4000
4 5000
all the way up to month 12....(sumofBal will vary)
2nd Query houses this data
Month SumofPaid
1 100
2 100
3 100
again this goes all the way up to month 12...(sumofpaid will vary)
What I am looking to create is a new query that will go something like this:
Month Percentage
1 [sumofpaid] for month 1/sum[sum of bal] for months 1-12
2 [sumofpaid] for month 2/sum[sum of bal] for months 1-11
3 [sumofpaid] for month 3/sum[sum of bal] for months 1-10
4 [sumofpaid] for month 4/sum[sum of bal] for months 1-9