Roman F
asked on
how to perform the calculation on two numbers in the joint query if numbers from different queries
I have a very big joint query. What you see only two lines I have a problem with:
SELECT "1", "Total Requested" ,[Res Total IVR]+ [ResTotal Rep] +[Non-Res Total IVR] +[Non-ResTotal Rep] from qrySummaryRec_1;
UNION ALL
SELECT "2", "Total Not Approved", qryCancelSummary_3.NotAppr oved FROM qryCancelSummary_3;
results is :
1 Total requested 30,000
2 Total Not Approved 20,000
how to add a new line to get the following
1 Total requested 30,000
2 Total Not Approved 20,000
3 Total Approved 10,000 ' 30000-20000
SELECT "1", "Total Requested" ,[Res Total IVR]+ [ResTotal Rep] +[Non-Res Total IVR] +[Non-ResTotal Rep] from qrySummaryRec_1;
UNION ALL
SELECT "2", "Total Not Approved", qryCancelSummary_3.NotAppr
results is :
1 Total requested 30,000
2 Total Not Approved 20,000
how to add a new line to get the following
1 Total requested 30,000
2 Total Not Approved 20,000
3 Total Approved 10,000 ' 30000-20000
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER