Thank you very much ItsMe.
I have copied that code exactly as written, but nothing is happening.
I guess it will have something to do with how I have tried to execute it, but I'm at a loss.
I have placed the code as follows:
Code:
Private Sub Command57_Click()
Dim strSQL As String
strSQL = "SELECT tbl_Scores.RAN, tbl_Scores.TEAM, tbl_Scores.DVN, tbl_Scores.FOR, tbl_Scores.RLT, tbl_Scores.AGT INTO 1963 " & _
"FROM tbl_Scores " & _
"WHERE (((tbl_Scores.RAN)<19) AND ((tbl_Scores.YEAR)=1963) AND ((tbl_Scores.AGE)=15));"
Debug.Print strSQL
End Sub
Is it okay to apply to a command button, or must I apply it some other way?