While T-SQL has the RAND() function, Jet SQL does not. The only way I can think of to do this is to query the entire recordset (and cache it if speed is an issue) and then select a random record in the middleware layer. (Assuming that you're using ColdFusion, you can do that by indexing your query as if it were an array, such as MyQuery.MyColumn[4] for the fourth record.)
I don't know why they didn't provide menu shortcuts for the Office help files, but Microsoft includes some pretty good help files for Access and Jet SQL. The Jet SQL help file is (by default) installed to C:\Program Files\Microsoft Office\Office\1033\JetSQL40.chm. |---------------------+---------------------------------------------------| |Eric A. Laney |Genius may have its limitations, but stupidity is | |Systems Engineer |not thus handicapped. | |LAN Optimization Team| | |Verizon Data Services| | |Voice: 813.978.4404 | | |Pager: 888.985.8519 | | |---------------------+---------------------------------------------------| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
