Here is the SQL:
INSERT INTO TblStatementDetail ( [Deposit#], Lease_Name, Gross_Production, Price, Withholding, Royalty )
SELECT [Forms]![FrmStatementDetail]![Deposit#] AS Expr2, [Forms]![FrmStatementDetail]![Name] AS Expr3, [Forms]![FrmStatementDetail]![Gross_Production] AS Expr1...