Maybe my reply to this post slipped through the cracks:
SELECT TOP 1
a.*
FROM
MyTable a
WHERE
a.id <= (
SELECT
MIN(b.id) + CONVERT(int, ROUND(RAND() * MAX(b.id), 0))
FROM
MyTable b
)
ORDER BY
a.ID DESC
will work in MSA...with a table/column name changes to suit.
David L. Penton, Microsoft MVP
JCPenney Application Specialist / Lead
"Mathematics is music for the mind, and Music is Mathematics for the
Soul. - J.S. Bach"
[EMAIL PROTECTED]
Do you have the VBScript Docs or SQL BOL installed? If not, why not?
VBScript Docs: http://www.davidpenton.com/vbscript
SQL BOL: http://www.davidpenton.com/sqlbol
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Damn, I need to run some thing like this on Access 2000
Tim Cadieux
(613) 947-4895
Technical Applications Analyst / Analyste des applications techniques
Client Services Section / Section de services � la client�le
Administrative Services Division / Division des services administratifs
Corporate Services Branch / Direction des services minist�riels
Facsimile / T�l�copieur : (613) 947-8799
-----Original Message-----
From: Anders Borum [mailto:[EMAIL PROTECTED]]
The NEWID() function is probably SQL Server only.
With regards
Anders Borum.
---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
