Crystal - Thanks so much!
--- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@...> wrote:
>
> Hi Mike,
>
> I have a sample database with a form where you can pick any table or query and choose a random record here:
>
> http://tech.groups.yahoo.com/group/MS_Access_Professionals/files/Crystal/
>
> then
>
> DB_RandomPicker_Crystal_110416_630p__ACCDB.zip
>
> to randomly order them, it would be easiest to create a field that you update with the random value
>
> for instance, create this field:
>
> Ordr, number (double)
>
> then this update query:
> UPDATE [tablename] SET t_People.Ordr = Rnd([numberField]);
>
> WHERE
> numberField is, ideally, a numeric unique field in the table
>
> then sort by Ordr
>
> you can also do this
>
> SELECT field1, field2, field3
> FROM tablename
> ORDER BY Rnd([numberField]);
>
> realize that if you do the last method and show the random numbers, they will not appear in order ... but they will be random ;) ... but you will not be able to get the same order again -- so if you need to see the same result in the future, create the Ordr field.
>
> called it Ordr since OrdEr is a reserved word
>
> warm regards,
> Crystal
>
> (: have an awesome day :)
>
>
>
> --- On Thu, 7/21/11, mithomas48 wrote:
>
>
> > Is there a way to randomly select
> > records within a recordset using an SQL Select
> > statement? The objective is, we are pulling a set of
> > records that meet certain criteria, but want to select a
> > specified number of those records randomly. So
> > basically, let's say we have 500 records in the
> > recordset. We want to randomly order these
> > records. Is there a way to randomly order a
> > recordset?
> >
> > Thanks in advance!
> > Mike
> >
>
Tidak ada komentar:
Posting Komentar