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
Printable View
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
First, you need to connect to the database. I assume this is in Access? (what version as well, please)
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
Oh right :) Hehehe silly me ;):p
That statement looks absolutely fine :)
Code:set recordset = database.openrecordset("Select * from Video Where play = 2 And Playing = 3 Order by Number;")