Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi everyone,
I have a problem that I cannot figure out , please help me. I have a colum J that contain the date such as 25/9/2005 0:00:00 (those date come from a select in my Access database). Then, I want to use those date in another select as follow: SQL.REQUEST(Conx,,4,"Select mesure from piezo where no_site like '" & $M$14 & "' and date_piezo = DATEVALUE(" & J23 & ")") As I know, this SELECT must return the mesure value, However it does not return any value. Any help will be appreciated Regards, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Select Case Statement | Excel Worksheet Functions | |||
How can I modify the SELECT statement? | Excel Programming | |||
SELECT statement | Excel Programming | |||
SQL Select statement with Date as | Excel Programming |