PDA

Click to See Complete Forum and Search --> : Access 97 and Random Numbers


Roadhead
Jan 17th, 2000, 03:15 AM
Hi,
i am a newbie to Access 97. I have 2 queries with like 20,000 records. Now i have to pick out 3 random records from each of these queries and then generate a report. Can somone help/ guide me on how to do this?? Please. All help is greatly appreciated.

Thanks

RoadH

sodhichd
Jan 18th, 2000, 09:23 AM
There must be a function like rnd() to generate random numbers.

Use it.

Manjinder Sodhi