muhammadadilmalik

Hi, You can also check for the higest value of the Identity Column for that student. this will be the last record added for that student.

<{POST_SNAPBACK}>

all the two solution are good but i think you have to send student name or login name in where clause also other wise it will give you general results

Select an additional field with a random value in it. Use your unique identifier, which I presume you've called ID, as the seed:

SELECT Rnd(Table1.ID) as Bunny, * From Table1 ORDER BY Bunny;

If you execute a query in forward-only, read only mode, this should work just fine, otherwise you might have some unusual behavior. If you are run this query in one of the dynamic modes and try to sort, then a new set of random values will be generated, and the old ones will be erased (and so will your old ORDER BY).

<{POST_SNAPBACK}>

my dear thanx for your replyi have try this query but here is a problem. i am making a system that will generate random question and every time unique set of question. please chek this query it will generate every time same set of values

how we can get random record where the no. of record is variable. i am using the database "MS Access"thanx

Yeah what is the other half?

<{POST_SNAPBACK}>

the other half is post first five to 10 lines