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,

Christina,
Check the actual string that you are sending. It looks as if it is something
like:
Select mesure from piezo where no_site like 'Some Value' and date_piezo =
DATEVALUE(39073)

whereas I guess you need something like:
"Select mesure from piezo where no_site like '" & $M$14 & "' and date_piezo
= " & DATEVALUE( J23 )

Also are the field names spelt correctly ?

NickHK

"Christina" <(E-Mail Removed)> wrote in message
news:308F69D1-4299-4FC3-A072-(E-Mail Removed)...
> 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,

Hi Nick,

Thank for your help. I follow your way and it works correctly. Thanks
again....

Regards,
Christina

"NickHK" wrote:

> Christina,
> Check the actual string that you are sending. It looks as if it is something
> like:
> Select mesure from piezo where no_site like 'Some Value' and date_piezo =
> DATEVALUE(39073)
>
> whereas I guess you need something like:
> "Select mesure from piezo where no_site like '" & $M$14 & "' and date_piezo
> = " & DATEVALUE( J23 )
>
> Also are the field names spelt correctly ?
>
> NickHK
>
> "Christina" <(E-Mail Removed)> wrote in message
> news:308F69D1-4299-4FC3-A072-(E-Mail Removed)...
> > 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,
>
>
>