sql statement question

[dlcpsycho]

ok i want to do the following

Select * From video where play = 2 and playing = 3 order by number

how would i make this work exactly

[parksie]

First, you need to connect to the database. I assume this is in Access? (what version as well, please)

[dlcpsycho]

well i got all the coding for that i just need the SQL statement i dont remember how to write a sql statement where u want more then 1 variable like where i want to play = 2 and playing = 1

[parksie]

Oh right Hehehe silly me

That statement looks absolutely fine

[shragel]

set recordset = database.openrecordset("Select * from Video Where play = 2 And Playing = 3 Order by Number;")