date and cdate

[ZeuBug]

hi i ve got a little problem

i do the request
SELECT Contacts.Nom, Contacts.Prenom, CDate([Historique_commercial].[Date_prochain_suivi]) as [Prochain suivi], Historique_commercial.Identification_suivi FROM Historique_commercial INNER JOIN Contacts ON Historique_commercial.Identification_client = Contacts.Identification_client WHERE Historique_commercial.Date_prochain_suivi <> '__/__/____' AND CDate([Date_prochain_suivi])>#11/22/00#

the format of the field date_prochain_suivi is a string.
the problem is when i execute the querystring, there ais no order in the condition WHERE and it try to convert in date the data which are = '__/__/____'
the problem is that i must do only one querystring to do that.

thanks if you have solution !

Raph
rchene@rockefeller.univ-lyon1.fr

 

[MichaelRed]

Ralph,

Not sure this is any help, but I do not understand why you are using the 'querystring' ('__/__/____') or the CDate. If you are attempting to have the querystring act as a parameter (the only idea which occurs to me for this part), then you need to add the parameter designation for the string.

The below line is a parameter([MyInv]) in a where clause from a query. The square brackets (&quot;[]&quot around MyInv designate this as a parameter.
WHERE (((tblSvcRec.InvNum)=[MyInv])



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over