VB6 trying to Query MS Access on DATE?

[jt]

This is my sql statement in my vb6 code:

My date variable name is, Fax_Today_Date devired by cdate(string)

Set rs = db.OpenRecordset("SELECT * from psusa WHERE PSUSA.fax_today and
PSUSA.Call_Date = Fax_Today_Date")

I get an error when it tries to execute. "Too few parameters. Expected
1.Error: 3061"

What am I doing wrong?

Thanks,
jt

[Earl]

WHERE
fax_today = Fax_Today_Date
AND
Call_Date = Fax_Today_Date

"jt" <jt****@hotmail.com> wrote in message
news:8t******************@tornado.tampabay.rr.com. ..

This is my sql statement in my vb6 code:

My date variable name is, Fax_Today_Date devired by cdate(string)

Set rs = db.OpenRecordset("SELECT * from psusa WHERE PSUSA.fax_today and
PSUSA.Call_Date = Fax_Today_Date")

I get an error when it tries to execute. "Too few parameters. Expected
1.Error: 3061"

What am I doing wrong?

Thanks,
jt

[Cor Ligthert [MVP]]

JT,

You got your answer from Earl with what is nothing wrong.

However, this is a language newsgroup for VB.Net which has something to do
with both the subjects you wrote as it has to do with everything about
computing.

However better newsgroups for your question are the specialized SQL or
VB.classic newsgroups.

The last are
Microsoft.public.vb (there are a bunch)

I hope this helps in future

Cor

[Herfried K. Wagner [MVP]]

"jt" <jt****@hotmail.com> schrieb:

This is my sql statement in my vb6 code:

Note that this is a VB.NET group. For VB6+database-related questions
consider posting to one of the groups in the
'microsoft.public.vb.database[.*]' groups hierarchy.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>