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.:-) |
|
|
|
|
|
|
I have a question