<div>
<div class="content wysiwyg-content">
I have a very big joint query. What you see only two lines I have a problem with: 
 
SELECT &quot;1&quot;, &quot;Total Requested&quot; &nbsp;,[Res Total IVR]+ [ResTotal Rep] &nbsp;+[Non-Res Total IVR] +[Non-ResTotal Rep] from qrySummaryRec_1; 
 
UNION ALL 
 
SELECT &quot;2&quot;, &quot;Total Not Approved&quot;, qryCancelSummary_3.NotApproved &nbsp;FROM qryCancelSummary_3; 
 
 
 
results is : 
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Total requested &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;30,000 
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Total Not Approved &nbsp;20,000 
 
 
how to add &nbsp;a new line to get the following 
 
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Total requested &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;30,000 
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Total Not Approved &nbsp;20,000 
3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Total Approved &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10,000 &nbsp; &nbsp; ' &nbsp; 30000-20000
</div>
</div>

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.NotApproved  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

how to perform the calculation on two numbers in the joint query if numbers from different  queries

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.