How can I choose random data

[Marwa Ahmed]

i have large amount of data- i want to choose from it random
one record only every time

[NeoPa]

We'd like to help if we can, but there is too little here to enable us to understand even what you're asking. Please explain the question in more than a single sentence, giving info we'd need to understand the question.

[ADezii]

@Marwa Ahmed
Here is a little System which I created, that will return the Primary Key Value of a Random Record within a Data Set. Once you have this PK Value, you will now have the capability to Filter for this Single Record in any manner you so desire. For this Demo, I used the Employees Table of the Northwind Sample Database with a couple of extra Records added. Any questions, please feel free to ask. I commented the code as much as possible without trying to be annoying (LOL):

Dim MyDB As DAO.Database
Dim rstRandom As DAO.Recordset
Dim lngNumOfRecs As Long
Dim lngRndRec As Long
Dim lngRndPKValue As Long
 
Set MyDB = CurrentDb
Set rstRandom = MyDB.OpenRecordset("Employees", dbOpenSnapshot)
 
Randomize       'Seed the Random Number Generator
 
With rstRandom
  .MoveLast: .MoveFirst     'Needed for accurate Record Count
  lngNumOfRecs = .RecordCount
    lngRndRec = Int(Rnd() * lngNumOfRecs) + 1       'Obtain a Randmom Record Position between
                                                    '1 and lngNumOfRecs
      'Move to that Random Record Position allowing for the Offset. AbsolutePosition
      'Property of a Recordset may be used under certain conditions, but is not 100% reliable
      .Move (lngRndRec - 1)
        'Retrieve the Value of the Primary Key [EmployeeID] at this Record
        lngRndPKValue = ![EmployeeID]
          Debug.Print "Random Record Number is: " & Format$(lngRndRec, "0000") & " with a Primary Key Value " & _
                      "of " & Format$(![EmployeeID], "0000")
End With
 
rstRandom.Close
Set rstRandom = Nothing

Sample OUTPUT for 16 Trails:

Random Record Number is: 0003 with a Primary Key Value of 0003
Random Record Number is: 0014 with a Primary Key Value of 0015
Random Record Number is: 0002 with a Primary Key Value of 0002
Random Record Number is: 0012 with a Primary Key Value of 0012
Random Record Number is: 0004 with a Primary Key Value of 0004
Random Record Number is: 0014 with a Primary Key Value of 0015
Random Record Number is: 0013 with a Primary Key Value of 0014
Random Record Number is: 0006 with a Primary Key Value of 0006
Random Record Number is: 0003 with a Primary Key Value of 0003
Random Record Number is: 0002 with a Primary Key Value of 0002
Random Record Number is: 0010 with a Primary Key Value of 0010
Random Record Number is: 0013 with a Primary Key Value of 0014
Random Record Number is: 0016 with a Primary Key Value of 0017