What would be the propper SQL code for a query if I want to copy certain data from one table to an empty table that has different field names? This is probably simple, but I new to SQL and Access.

Thanks for your time.

create an append query using the query qizard.
Look for some examples on using teh append query. It is really very simple.