Hi,
Thank u now the statement is working i applied like this ....below,
Code:
If myCheckBoxes(i).Checked = True Then
                Debug.Print(Me.myCheckBoxes(i).Text)
                'fnICCandBdgYearFilter = fnICCandBdgYearFilter + " OR (tblAnnualBudget.ICC= """ & Left(me.myCheckBoxes(i).Text, InStr(1, me.myCheckBoxes(i).Text, "-") - 1) & """)"
                Dim a As String()
                a = Split(Me.myCheckBoxes(i).Text, "-")

                fnICCandBdgYearFilter = fnICCandBdgYearFilter + " OR (tblAnnualBudget.icc= """ & (a(0)) & """)"
            End If
            Debug.Print(fnICCandBdgYearFilter)
        Next i
        QStr3 = Mid(fnICCandBdgYearFilter, 4)
        fnICCandBdgYearFilter = "Select *  into tblICCAnnBdgYearFilterTemp from tblAnnualBudget   where  " & QStr3 & ""        
Debug.Print(fnICCandBdgYearFilter)

The Red color code indicates,
Here i want to send the data into one temp table called "tblICCAnnBdgYearFilterTemp" .
Is this right procedure to send the data into temp table or any other way we create temp table???
B`se the above red color code is not creating temp table in my DB, after debug ......
Plz give suggesstions regarding to this
Thanks