Does anyone know how to create a RANDOM database Query in Frontpage2002/Access?

D

Dan

What is the SQL query for taking a random query out of an Access
database and displaying it on a web page?

For example, if I have a database that has "Mon" (Month), "Dy" (Day)
and "Yr" (Year), plus a "Description" in my database populated with
data, how would I go about calling up a random event that happened?

I would like my results to look similar to this:

On November 24, 2000, "102 Dalmatians" was released to theatres.
(it was, really!)

However, if someone refreshes the page, it will come up with a
different event.

Thanks to anyone who can help.
 
Top