P
Patrick
I have a table that contains records to be worked. Among the fields is a
received date (already populated) and a rep id (not populated). I would like
for a supervisor to be able to assign a specific number of records, to a
specific rep id, for a specific date. The volume will vary, so I'd like the
supervisor to have some flexibility as to how many records are assigned to
each rep. I thought I'd use an UPDATE query, but I don't know how to limit
the number of records that would be updated with the rep id, for the
specified date. Is there a way for the supervisor to be prompted for the
number of records to update, and how would this value be used in the UPDATE
query?
received date (already populated) and a rep id (not populated). I would like
for a supervisor to be able to assign a specific number of records, to a
specific rep id, for a specific date. The volume will vary, so I'd like the
supervisor to have some flexibility as to how many records are assigned to
each rep. I thought I'd use an UPDATE query, but I don't know how to limit
the number of records that would be updated with the rep id, for the
specified date. Is there a way for the supervisor to be prompted for the
number of records to update, and how would this value be used in the UPDATE
query?