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

use between clause or smaller (<=) to get value from 1-10

Random numbers, where High is the upper limit and low is the lower limit of the range desired:

Randomize Timer
Rand = Int((High - Low + 1) * Rnd) + Low

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.