Search results

I currently have a left join pulling data from a table inputted weekly with production of workers. I developed a new table which the workers process the claims, and it enters a entry for each item processed. I want to change over from the left join of the lump sum (entered by hand weekly)...

would anyone mind helping me with the query below. i am looking to pool a table and to pull a set number of records randomly for each processor. from what i am understanding, i need to calculate a rnd() field, then sort by that and use the top query, but i am having trouble. any help would be...