query into the table

[mfuada]

Hi guys... is it possible to save the result of the query into a new table?
i have a query of total sum of field in some table.. and I'm going to display that query into a report and then save the result of the total sum query(the value) into a new table, so that i have a documentation of the total sum of my data in each month....
could u guys help me with that and should i use another query or use VBA?
Thanks...

 

[John Big Booty]

It certainly is have a look at "Make Table Query..." in the Query Type button on the main tool bar when you have a query in design view.

 

[mfuada]

Thanks a lot...