I have a query of a bunch of records and I'm trying to assign a random number to each one. The issue is when the data pulls, it's giving the same number to each record. My expression is below:
Random: Int((999-100+1)*Rnd()+100)
I've also tried just Rnd() and it also doesn't work.
Any idea what I'm doing wrong