By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,635 Members | 2,174 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,635 IT Pros & Developers. It's quick & easy.

Picking Random Values From A Table

P: n/a
I have a name with initials and names of Reps.

I want to create a function that will return any number of records I
specify of random initials.

For instance, if I call the function and want to return 400 random
initials.

The reason I am doing this is because I created some test data in a
database and the only thing I need to assign each record to a Rep.

Thanks

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Not 100% sure I know what you're after (random number of records or
random initials), but have a look at this:

http://www.mvps.org/access/queries/qry0011.htm

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.