help with sql in excel
"WHERE
(FORM_XD.TEAM=20)"
would be
"WHERE
(FORM_XD.TEAM=" & Worksheets("Sheet1").Range("A1").Value & ")"
--
Regards,
Tom Ogilvy
"aneurin" wrote in message
om...
hi i have the below sql statement
"SELECT TRUNC(FORM_XD.DAY_OF_WEEK),
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) & "WHERE
(FORM_XD.TEAM=20)" & Chr(13) & "" & Chr(10) & "ORDER BY
TRUNC(FORM_XD.DAY_OF_WEEK)"
it connect to the database to a table called form_xd
and only brings in the data where team = 20
the problem i am having is that i have to state this criteria in the
sql statement
what i would like to do is to get this criteria form a cell on sheet 1
hope someone can help
aneurin
|