Hello, found this site while searching through google. Hopefully someone can help me. (It's a challenge )
Right now, I am building a software that needs to assign leads to sales people who are active. I have two tables and here's the outline:
tbl1 = fresh leads data information
tbl2 = active sales people
At night, it needs to randomly distribute to all active sales people. The schedule task is easy to config, but I can't seem to do a right query that would work. Here's what I currently have:
UPDATE tbl1 SET saleid2 = (select RND(saleid) from tbl2 where status=-1) WHERE saleid=0;
(WHERE saleid=0;) - tbl1 needs to only update leads that has "not" worked on
(select RND(saleid) from tbl2 where status=-1) - I only want to pull active sales people.
When I run this query in Access, it shows this error: " Operation must use an updateable query "
PS: The permission is set correctly on my test server.