Access and FrontPage - Randomize Results Displayed

[Darlene]

I have a database results page that was created with the Database Results
wizard and I would like to have the results appear in a random order
independent of how they are entered into the database. I would like this to
happen every time a user refreshes that page.
Any ideas?

 

[Dwayne Conyers]

I have a database results page that was created with the Database Results
wizard and I would like to have the results appear in a random order
independent of how they are entered into the database. I would like this
to
happen every time a user refreshes that page.
Any ideas?

You would have to change your database query that selects the records.



--
Give Dad the BEST Father's Day Ever!
http://www.dwacon.com/holidays/fathers_day.html





---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 0524-0, 06/13/2005
Tested on: 6/13/2005 12:42:25 PM
avast! - copyright (c) 1988-2005 ALWIL Software.
http://www.avast.com

 

[Darlene]

Dwayne,
Can you give me an example. Right now the visitor enters their "area code"
in a form and the form passes this to the data results page and it is only
displaying the records that contain that areacode.
I can sort it by field values, but again, I would like for it to be random.
Thanks
Darlene