Now I made a query by create query by wizard, and after that I found out of how to call that query from a form...But my question how can I use the value in the query table that I'm calling from my form...e.g My query is "Lecture Query" this query is going to calculate the total number of lecture by each lecturer_id. When I calling this query by using a
command button --> Miscellaneous --> Run Query
after I execute this my query table appear when I press Run Query button. It's appear the Lecturer_id and the sum of lecture of each lecturer but I want to insert each staff_id and each total lecture to another table....

I want to know where can I find the query table and how to insert the query table result to another table..

Thank you for you help