J
Jiminic
Hello everyone
I have a table with roughly 40000 records, that gets more records added
weekly. From this table my staff work through each record and add a closed
date when finalised. The table the staff are working off contains an
"Investigated By" field which is linked to the staff members name on a
seperate table, the default investigated by name is "Exception". At this
point, only one person can work on the records at a time. The amount of
records that get added weekly varies and I want to be able to allocate an
employees name to each new record so that they show up in their "Pending
List". As I said, the amount of records varies each week, and I do not know
how to make a query automatically count the number of new records, divide
that number by the amount of staff and assign a name to the record.
if anyone has any ideas I would greatly appreciate your help!
I have a table with roughly 40000 records, that gets more records added
weekly. From this table my staff work through each record and add a closed
date when finalised. The table the staff are working off contains an
"Investigated By" field which is linked to the staff members name on a
seperate table, the default investigated by name is "Exception". At this
point, only one person can work on the records at a time. The amount of
records that get added weekly varies and I want to be able to allocate an
employees name to each new record so that they show up in their "Pending
List". As I said, the amount of records varies each week, and I do not know
how to make a query automatically count the number of new records, divide
that number by the amount of staff and assign a name to the record.
if anyone has any ideas I would greatly appreciate your help!