Work completed 2 different dates

[LG]

I have a db built for Metrics and inventory. I have built a form where
supervisor will assign work and processors will go in another form and put
their completed work. My problem is when supervisor assigns 100 but the
processor only completes 50 and enters the complete date. There is still 50
outstanding in inventory but when the processor goes in the next day they
can't see it because they aleady entered a complete date prior. The only
solution I had was to edit the assigned from the original and reassign with
the same receive date. Any ideas?

 

[Piet Linden]

I have a db built for Metrics and inventory.  I have built a form where
supervisor will assign work and processors will go in another form and put
their completed work.  My problem is when supervisor assigns 100 but the
processor only completes 50 and enters the complete date.  There is still 50
outstanding in inventory but when the processor goes in the next day they
can't see it because they aleady entered a complete date prior.  The only
solution I had was to edit the assigned from the original and reassign with
the same receive date.  Any ideas?

Sounds like your design is wrong. You have it set up so that the
table can only record completed assignments (or whatever they are) if
the whole batch is complete. You need another field indicating how
many of the entire batch were completed. Then you can compare/do
math. Then you can create a simple select query to find any partially
complete batches.

 

[LG]

The problem is that I need to have the first completed date as well for the
processors work per hr per day. But I need to also have a inventory off the
same information. If i enter a completed date for say processor A the
inventory assigned goes away even if the whole batch is not completed. I
need to have the field read off the complete date to also determine TAT for
all records involved.
Any help is appreciated

 

[Bob Quintal]

The problem is that I need to have the first completed date as
well for the processors work per hr per day. But I need to also
have a inventory off the same information. If i enter a completed
date for say processor A the inventory assigned goes away even if
the whole batch is not completed. I need to have the field read
off the complete date to also determine TAT for all records
involved. Any help is appreciated

I'll say the same as Piet: Your design is wrong,

You actually need 2 tables, with a One To Many relationship between
them. The first records The supervisor data: that is date assigned,
quantity assigned, job number for the batch.

The second table is for the processors. It should contain the date
worked, quantity complete (for that day) and the job number. This
table can contain many records which are related to the one
supervisor record. Open Work is then the sum of the many-side
quantities being less than the single supervisor quantity.