sudhir kannan 0 Newbie Poster

Set RS = DB.OpenRecordset("Select A8,A9 from A_A WHERE A3='" & Trim(RSB.Fields(0)) & "' AND A1='" & Month("01") & "' ORDER BY A1")