Random Name

[coucar3456]

Is there a way in a query to execute a random function where employee names in below fields built (field_1) and validated (field_2) are never being the same person.


Field1:
Carter
Jon
Nick
Gregg
Brady

Field2:
Jon
Carter
Gregg
Brady
Nick

 

[iliace]

The most trivial way is to set up a column next to Field2 with random numbers, then sort on it. In this example, each time you sort A8:B13 on column B, you will get a new match next to Field2.

Excel Workbook
	A	B
1	Field1:
2	Carter	Nick
3	Jon	Gregg
4	Nick	Brady
5	Gregg	Jon
6	Brady	Carter
7
8	Field2:	Sort
9	Nick	0.827949
10	Gregg	0.056451
11	Brady	0.676668
12	Jon	0.712612
13	Carter	0.977777
Sheet1

 

[james_lankford]

this is the Access forum
not Excel

 

[iliace]

Oh, sorry.
Then you would not be able to use this approach directly, Access Rnd() function returns the same value for each row.