M
Mr-Re Man
I have two forms set up, one is the main form which collects data from the
user on incoming mail, eg. date received, name, address, mail for, response
date etc.
Within this form I have a continuous subform that allows users to
re-allocate a piece of mail to another colleague. Very basic form, it uses
the mail_id number to link them together, and the user selects the name of
the officer and enters the date they re-allocated it.
I am trying now to provide statistics on mail throughput, it is fine to work
off a query from the main form which gives everything I want, the challenge I
am faced with is when mail has been re-allocated to 1, 2 or more officers. I
need to join the subquery in somehow to indicate who the last person dealing
with the mail was, otherwise the poor person who it was addressed too, may be
under some pressure if outstanding mail keeps flagging up as himself.
Any help would be appreciated, I have been trying to search for posts
throughout the board but am getting nowhere fast.
many thanks
user on incoming mail, eg. date received, name, address, mail for, response
date etc.
Within this form I have a continuous subform that allows users to
re-allocate a piece of mail to another colleague. Very basic form, it uses
the mail_id number to link them together, and the user selects the name of
the officer and enters the date they re-allocated it.
I am trying now to provide statistics on mail throughput, it is fine to work
off a query from the main form which gives everything I want, the challenge I
am faced with is when mail has been re-allocated to 1, 2 or more officers. I
need to join the subquery in somehow to indicate who the last person dealing
with the mail was, otherwise the poor person who it was addressed too, may be
under some pressure if outstanding mail keeps flagging up as himself.
Any help would be appreciated, I have been trying to search for posts
throughout the board but am getting nowhere fast.
many thanks