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
Jump to Postuse between clause or smaller (<=) to get value from 1-10
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
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.