D
Damien
I've got 101 records in a table, tbl_staff. I want to
update field 'allocation' with the key from tbl_users, but
I want to spread the allocation evenly amongst the records
in tbl_users.
eg if there were 5 records in tbl_users, then 4 users will
have 20 records, and 1 user will have 21 records
(allocated to them in tbl_staff).
What's the best way to do this using an update query or
queries ?
The number of records in tbl_users can vary, so that kind
of rules out using TOP; I was also hoping to do this in
one query...
Thanks
Damien
update field 'allocation' with the key from tbl_users, but
I want to spread the allocation evenly amongst the records
in tbl_users.
eg if there were 5 records in tbl_users, then 4 users will
have 20 records, and 1 user will have 21 records
(allocated to them in tbl_staff).
What's the best way to do this using an update query or
queries ?
The number of records in tbl_users can vary, so that kind
of rules out using TOP; I was also hoping to do this in
one query...
Thanks
Damien