my sql query is this
Set rs = conn.Execute("SELECT COUNT(Question) FROM QnE where fldChapter = 10")
on my tble that fldChapter have a value of 1,2,3,4,5,6,7,8,10~~~~~,20
and im getting a random cell value form fldChapter
HOW can i get a random cell value form 1~10 only???
pls help me really needs to solve this