hi i have an sql statment that is run in excelwhich works fine but if
i want to change the where criteria of the statment i have to go into
the code and change it there
what i would like to do is link the where criteria to a cell on one of
this is my attempt
"WHERE(FORM_XD.TEAM=" & Worksheets("Sheet1").Range("A1").Value & ")"
but it does not want to work
below is the full select statement
TO_CHAR(FORM_XD.DAY_OF_WEEK,'HH24:MI'), FORM_XD.TEAM, FORM_XD.TALK,
FORM_XD.SALES, FORM_XD.WAIT" & Chr(13) & "" & Chr(10) & "FROM
EASY.FORM_XD _FORM_XD" & Chr(13) & "" & Chr(10) ...