Hi,
I have following query that takes 10 random records from one table (tblaccounts) and inserts that into another table (tblrandom).
SELECT TOP 10 tblaccount.*, Rnd([accnum]) AS Randnumber INTO tblRandom FROM tblaccount ORDER BY Rnd([accnum])
The above query works fine for that purpose.
However, I want to just update 10 Random records in tblaccount to set the following field:
SET status = "Assigned"
Does anyone know how to do this using an update statement please? Thanks!
I have following query that takes 10 random records from one table (tblaccounts) and inserts that into another table (tblrandom).
SELECT TOP 10 tblaccount.*, Rnd([accnum]) AS Randnumber INTO tblRandom FROM tblaccount ORDER BY Rnd([accnum])
The above query works fine for that purpose.
However, I want to just update 10 Random records in tblaccount to set the following field:
SET status = "Assigned"
Does anyone know how to do this using an update statement please? Thanks!
