Count from a table and update the counted numbers to another table

[baijuep]

i have a query it correctly displays output as i require. i want to update/store the output query to a table named ustate. my query is as under

SELECT Auth.nit, UC+UL+UC AS Aut, (select count(NO) from Pers where nit=Auth.nit and rOrd>4) AS Present, (SELECT COUNT(no) FROM pers WHERE nitFrom = auth.nit) AS DIn, (SELECT COUNT(no) FROM pers WHERE nitTo = auth.nit) AS DOut, Present-Dout+Din AS Held
FROM Auth
WHERE (((Auth.Type)='tata'))
ORDER BY Auth.nit;

 

[Rx_]

Do you want to turn it into a Make-Table Query?
that would take your output and put it int a table named ustate.

 

[baijuep]

i added INTO USTATE and it got saved to the new table
now the problem is when i run the query it takes only 30 seconds to calculate and display but when i use INTO USTATE it takes 4-7 minutes to get finished and asks if i want to delete the existing how can override both problems