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!

What is the primary key field for this table? Also actual names for both of 
the tables and fields such as staff members would help us help you.
-- 
Jerry Whittle, Microsoft Access MVP 
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Jiminic" wrote:

> 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!

Hi Jerry

Thanks for your reply. In answer to your questions, the primary key field 
for the table is “ComplaintID”. The table names are 

“Complaints” (order and name of Fields is as follows: ComplaintID, 
CustomerID, DateReceived, ReceivedBy, CMSRef, Policy/ReferenceNo, Medium, 
MediumSource, Policy Type, TypeOfContact, Department, Issue, IssueType, 
IssueSubType, UnderlyingIssue, UnderlyingSubIssue, ExpectedCompletion, 
DateFinalised, Cost, Comments, InvestigatedBy, Status, BusinessMaintained, 
FileResolved, ErrorConsultant, Archive, EscalatedClaim, Trigger, Last 
Contact, Notes, ClaimNumber, 48H, 7D, EGWR, ERRMAN, FBO)

and 

“Staff Names” (order and name of Fields is as follows: Staff ID, Log in, 
Staff Name, FirstName, Team, Class). The class field in the Staff Names table 
is used to show whether a staff member is working, or is on leave.

I hope that this is the information you were after, and thank you for your 
assistance


"Jerry Whittle" wrote:

> What is the primary key field for this table? Also actual names for both of 
> the tables and fields such as staff members would help us help you.
> -- 
> Jerry Whittle, Microsoft Access MVP 
> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
> 
> 
> "Jiminic" wrote:
> 
> > 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!