sql problen 1

[ozpeppers]

Hi

I wish to locate a record within an access database using an adodc sql statement

Is it possible to query a access 97 database using an adodc sql select statement with a variable within that statement?

i.e.

SELECT * FROM comsumers WHERE consumerID = variable

Cheers In Advance

Mark

 

[woyler]

MySQL = "SELECT * FROM comsumers WHERE
consumerID ='" & variable & "'"

 

[ozpeppers]

Cheers

Still fairly new to this vb so...

I'm guessing that I put the

MySQL = "SELECT * FROM comsumers WHERE
consumerID ='" & variable & "'"

into the vb code and then call MySQL in the adodc recordsource

Right or totally wrong... I think the latter probably

Cheers woyler

Mark