Output Query to a TABLE

[vvasudev]

hello,


I have a Query which gives me output as 2 fields

- Sales for JAN
-Units for JAN

I also have a TABLE by the name FINAL TEST which has fields for Sales and Units for all the 12 months.

I want to insert the query result to the TABLE FINAL TEST..Please Advice

 

[Galaxiom]

Change the query type to Append and indicate the table to be updated when asked.
Put the reqired field destination fields in the Append To cell of the design grid.