Get results from Query Into Table

[ddrew]

This is a rael daft question, but how do I get the results of a query into a table?

 

[steallan]

Create a new MAke Table Query, where you set the First query as what you want the Make table query to use.

Make Table Query is one of the selections in the menu for query type, along with Delete, select, append etc

 

[ddrew]

OK I think the wayto do this is as you suggest Pat, as an Append Query. What I want to do is run the query on an after update on a combobox. It works OK but I dont want the results , i.e the table to appear, I basically want it to run in the background. How can stop the table appearing but still run the query. The reason behind this is to display the results in a seperate form.

 

[ddrew]

OK! I've been battleing this for a while now and am in real danger of losing myself. Let me explain. I have a number of different forms lets say Unit1, Unit2, Unit3 and Unit4. On each form is a total called TotalWRUnit1, TotalWRUnit2, TotalWRUnit3, TotalWRUnit4,I now need to create a query that adds all of those totals up and then sticks it in a table, lets say Tables![Totals]![WRTotal]. An help appreiciated, thanks!

 

[neileg]

So where is the data? Unless the forms are unbound, I assume there are some tables, somewhere?

Are you sure you need to stick the total in a table? It is good practice not to store the results of a calculation unless there is a good reason. Your new form can be based on a query.