Random Record

[expublish]

Is it possible to create a query that will display 1 random record when run?

If so, how?

Scott.

 

[Fizzio]

Have a look here ex.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q208855 (2k)

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q128874 (97)