Create New Records based on Query (1 Viewer)

[basshead22]

Hi All, Happy Holidays!!


How do I create new records based on the results of a query?

I opened the query results in a form then I want to have a button that basically creates new records based off the query data ... is this possible?

:banghead:

Thanks in Advance!!

 

[pbaldy]

An append query:

INSERT INTO TableName(Field1, Field2)
SELECT Field1, Field2
FROM YourQueryName