S
simsjr
Anyone know a simple SQL statement to retrieve any 5 records from a query?
Doesn't matter which 5 either.
Doesn't matter which 5 either.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Graham Mandeno
Use the TOP predicate:
SELECT TOP 5 .... FROM ....
SELECT TOP 5 .... FROM ....
S
simsjr
Right on!
Now just for kicks, is there any way to randomize the 5 records I get back?
Now just for kicks, is there any way to randomize the 5 records I get back?
Graham Mandeno said:Use the TOP predicate:
SELECT TOP 5 .... FROM ....
--
Good Luck!
Graham Mandeno [Access MVP]
Auckland, New Zealand
simsjr said:Anyone know a simple SQL statement to retrieve any 5 records from a query?
Doesn't matter which 5 either.
J
John Vinson
Right on!
Now just for kicks, is there any way to randomize the 5 records I get back?
SELECT TOP 5 ...
FROM tablename
ORDER BY Rnd([ID])
where ID is some non-negative numeric field in your table.
John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps