Oct 15, 2003 #1 rushie84 Programmer Jul 31, 2003 8 0 0 US How can i query a list of names to get a randomly selected list of 5% of the people? Thanks!
Oct 15, 2003 #2 Cagliostro Programmer Sep 13, 2000 4,226 0 0 GB what database are you using? Ion Filipski ICQ: 95034075 AIM: IonFilipski filipski@excite.com Upvote 0 Downvote
Oct 15, 2003 Thread starter #3 rushie84 Programmer Jul 31, 2003 8 0 0 US Access database Upvote 0 Downvote
Oct 16, 2003 #4 JamesLean Programmer Dec 13, 2002 3,059 0 0 GB This is a SQL Server forum. Please post this question in the Access forum. --James Upvote 0 Downvote
Oct 16, 2003 #5 JamesLean Programmer Dec 13, 2002 3,059 0 0 GB Oops, sorry. Forgot where I was for a second there! You would still be better off posting this in the Access forum though. --James Upvote 0 Downvote
Oops, sorry. Forgot where I was for a second there! You would still be better off posting this in the Access forum though. --James
Oct 16, 2003 #6 Cagliostro Programmer Sep 13, 2000 4,226 0 0 GB you could solev your problem if you add an integr random number colum to your table like this alter yourtable add column(yourRndColumn integer) update yourtable set yourRndColumn = Rnd() * 20 the last step select * from yourtable where yourRndColumn = 1 instead of 1 you could also put a any other random numbers. so you will select randomly 5% of Ion Filipski ICQ: 95034075 AIM: IonFilipski filipski@excite.com Upvote 0 Downvote
you could solev your problem if you add an integr random number colum to your table like this alter yourtable add column(yourRndColumn integer) update yourtable set yourRndColumn = Rnd() * 20 the last step select * from yourtable where yourRndColumn = 1 instead of 1 you could also put a any other random numbers. so you will select randomly 5% of Ion Filipski ICQ: 95034075 AIM: IonFilipski filipski@excite.com