Random number between 1 and 6 to groupwise

[kid]

My table has more than 100 groups. (Group1,Group2....).
I want to update a column with random number between 1 and 6 in each group.
Each group has maximum 25 members and some groups have below 25 members.

[orange]

Duplicated post?? removed

[orange]

What is special about the range 1-6?

See https://support.office.com/en-us/art...a-ed8fb35c1d80

[kid]

Yep.. I can use Rnd () function. But I am struggled in use this in groupwise

[orange]

Ok, then tell us in simple,plain English --no database jargon -- what you are trying to accomplish.
Perhaps give a clear example so readers understand the requirement.
I am not familiar with groupwise.


You may find this article helpful.

Good luck with your project.

[CJ_London]

My table has more than 100 groups. (Group1,Group2....).
I want to update a column

from this brief description, it sounds like your table is not designed correctly. An incorrect design can either result in a horribly complex solution or more often not a viable solution