[RESOLVED] whats the error in the sql statment code?

Hi
whats the error in the sql statment code?

Code:

---

Adodc1.RecordSource = "select * from recept_Query where cheq_num like'" & Text8.Text & "' and where rec_type like'" & Text7.Text & "'"

---

ineed to make to condition in one selec statment like tha code?
thank yo

The keyword Where appears twice, once is enough.

You also dont have the LIKE wildcard character ("%") in your sql string unless you plan on adding it to the textbox input manually.

no ineed to check too fields in one time

Quote:

---

Originally Posted by iyadd

no ineed to check too fields in one time

---

You can have multiple fields in your where clause

how?

Code:

---

SELECT * FROM Table1 WHERE Field1 LIKE '%blah%' AND Field2 LIKE '%stuff%'

---

The corrected code for the posted question is ...

Code:

---

Adodc1.RecordSource = "select * from recept_Query where cheq_num like '%" & Text8.Text & "%' and rec_type like '%" & Text7.Text & "%'"

---

RobDog888 THanks you very much......its correct and run succefully.....
thank you too
iyadd

No prob. Glad to help :)

Ps, dont forget to Resolve your thread fromt he Thread Tools menu and choose "Mark Thread as Resolved" ;)

Ok tahnk you too