need query to random update field with 0,1,2,3 or 4

[Rob]

Hi, I need to update a field with a random number 0 1 2 3 or 4 in order to
test a report. Can anyone set me up with a query for this? There is no
criteria to update from, it should update all records in the table.

Thanks,
Robbie

 

[John W. Vinson]

Hi, I need to update a field with a random number 0 1 2 3 or 4 in order to
test a report. Can anyone set me up with a query for this? There is no
criteria to update from, it should update all records in the table.

Thanks,
Robbie

UPDATE yourtable
SET yourtable.fieldname = Int(5*Rnd([ID]));

where ID is some non-negative numeric field within the table.

John W. Vinson [MVP]

 

[Rob]

Thanks!

Hi, I need to update a field with a random number 0 1 2 3 or 4 in order to
test a report. Can anyone set me up with a query for this? There is no
criteria to update from, it should update all records in the table.

Thanks,
Robbie

UPDATE yourtable
SET yourtable.fieldname = Int(5*Rnd([ID]));

where ID is some non-negative numeric field within the table.

John W. Vinson [MVP]