SQL characters at the end of the statement 1

[Brogrim]

I have written the following SQL statemenbt when I try to execute I get a message

"Characters found after end of SQL statement"

The statement is

Function test()
On Error GoTo test_Err

DoCmd.RunSQL "SELECT tblStaffMon3.StaffID, tblStaffMon3.MonthID, tblStaffMon3.SupportServicesID, tblStaffMon3.Details, tblStaffMon3.Numbers INTO tblSM FROM tblStaffMon3 WHERE (((tblStaffMon3.MonthID) Between [Forms]![frmReportStaffMon]![cboMonth1ID] And Forms!frmReportStaffMon!cboMonth2ID));, -1"


test_Exit:
Exit Function

test_Err:
MsgBox Error$
Resume test_Exit

End Function

Thanks in advance

 

[mp9]

Try:

DoCmd.RunSQL "SELECT tblStaffMon3.StaffID, tblStaffMon3.MonthID, tblStaffMon3.SupportServicesID, tblStaffMon3.Details, tblStaffMon3.Numbers INTO tblSM  FROM tblStaffMon3  WHERE (((tblStaffMon3.MonthID) Between [Forms]![frmReportStaffMon]![cboMonth1ID] And Forms!frmReportStaffMon!cboMonth2ID));", -1

http://www22.brinkster.com/accessory/

 

[Brogrim]

I have included another parameter and it give's a complie error.

DoCmd.RunSQL "SELECT tblStaffMon3.StaffID, tblStaffMon3.MonthID, tblStaffMon3.SupportServicesID, tblStaffMon3.Details, tblStaffMon3.Numbers INTO tblSM" From tblStaffMon3 WHERE (((tblStaffMon3.StaffID)=[Forms]![frmReportStaffMon]![cboFSWID]) AND ((tblStaffMon3.MonthID) Between [Forms]![frmReportStaffMon]![cboMonth1ID] And [Forms]![frmReportStaffMon]![cboMonth2ID]));", -1

Thanks again, I am trying

 

[PHV]

You may try this:
DoCmd.RunSQL "SELECT StaffID, MonthID, SupportServicesID, Details, Numbers INTO tblSM" _
& " FROM tblStaffMon3 WHERE StaffID=[Forms]![frmReportStaffMon]![cboFSWID] AND (MonthID Between [Forms]![frmReportStaffMon]![cboMonth1ID] And [Forms]![frmReportStaffMon]![cboMonth2ID]);", -1


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886