Access and FrontPage - Randomize Results Displayed

D

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?
 
D

Dwayne Conyers

Darlene said:
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
 
D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top