Double Query Help

[axg275]

Hey Guys.

I am having huge problem with trying to execute a query it just does not make a table its stuck on running the query mode and does not move. What i did was found an article on how to create a query online and modified it for my table. I wanted to see if its possible for me to write this query in the design mode as opposed to the sql code. Here is the code that I wrote that does not run to make the table:

SELECT

E.Wells, E.Tops_AZPU_AG,
E.Tops_AZPU, E.EVENT_DATE,
E.KH_Logged_,
(SELECT SUM(E1.KH_Logged_) FROM tblEvent AS E1 WHERE E1.Tops_AZPU_AG=E.Tops_AZPU_AG AND E1.EVENT_DATE=E.EVENT_DATE) AS TOTAL_KH_Logged_,
E.KH_Logged_/TOTAL_KH_Logged_*100 AS PCT_KH_Logged_ INTO tbl_Res_byPercent

FROM tblEvent AS E;

I followed this thread to create my query : https://stackoverflow.com/questions/...in-access-2016

I was trying to figure out how to get this query made in the two steps in the design mode. I am really stuck. Can someone help me out?

Thank you

[ranman256]

make Q1 a select query, to sum items.
make Q2 a make table, using Q1.

if Q1 works, then Q2 should too