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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 I have a question

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

Go to Top of Page

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.
Go to Top of Page

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
Go to Top of Page

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]



Brett

8-)

EDIT: OK< what's the syntax...help doesn't say how

Go to Top of Page

MattieBala69
Starting Member

30 Posts

Posted - 2005-04-21 : 13:15:02
Thanks Brett i did not realize we had Access.
:-)
Go to Top of Page
   

- Advertisement -