Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
MattieBala69
Starting Member
30 Posts |
Posted - 2005-04-21 : 12:42:44
|
I know this is a SQL site . But if its ok to ask . Is there a way to do a random selection in Access and if there is how to do it.Thank you soooooooo much |
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2005-04-21 : 13:01:45
|
NO newID in MS Access, in MS Access use rand() function to generate random seed. Are you using any front end application like ASP or VB then generate a random number pass it to your SQL query |
 |
|
MattieBala69
Starting Member
30 Posts |
Posted - 2005-04-21 : 13:04:56
|
no i am not. I am really new to this . The problem i have to pick randomly 265 records from a table randomly. |
 |
|
MattieBala69
Starting Member
30 Posts |
Posted - 2005-04-21 : 13:06:54
|
will u be able to give an example of how to do it . That is if u dont mind . Thank u soo much |
 |
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-04-21 : 13:12:11
|
We do have an Access forum right [url=http://www.sqlteam.com/forums/forum.asp?FORUM_ID=3]here[/url]Brett8-)EDIT: OK< what's the syntax...help doesn't say how |
 |
|
MattieBala69
Starting Member
30 Posts |
Posted - 2005-04-21 : 13:15:02
|
Thanks Brett i did not realize we had Access.:-) |
 |
|
|
|
|