collect data in a form control

I have a control on my form that my receiving department has to enter the
amount of items that have come in on a particular shipment. I need this
field to start over at 0 after the form is closed but the value that is place
in this field needs to be collected into another field. I'm trying to add up
all of the items that have come in total for a particular order over a period
of time. I have no idea how to make this happen here are my controls on my
form:
vendor item#, description, qty ordered, qty received, qty remaining,
delivery status
Thank you in advance for any ideas.

Hi,

You won't be able to with that table design, the best you will get is the
number outstanding. Presumably you increase the qty received and reduce the
qty remaining each time items are booked in?

What would be more efficient, would be to separate the Order table from the
Orders received so that you would have one record for each time items were
booked in the OrdersRecvd table, where you could also record the date/time,
operator doing the booking in etc. You would then calculate the qty remaining
as the difference between the qty ordered and a sum of the qty's received.

Is vendor item # the foreign key to the vendors table? What is the
description describing and what is the delivery status used to record? Are
there any other fields referenced in that form and how many tables does that
info come from?

TonyT

"kms" wrote:

I have a control on my form that my receiving department has to enter the
amount of items that have come in on a particular shipment. I need this
field to start over at 0 after the form is closed but the value that is place
in this field needs to be collected into another field. I'm trying to add up
all of the items that have come in total for a particular order over a period
of time. I have no idea how to make this happen here are my controls on my
form:
vendor item#, description, qty ordered, qty received, qty remaining,
delivery status
Thank you in advance for any ideas.

Thanks Tony I was trying to avoid another table. Currently the form I am
using record source is a table called PO and a query named PO detail
received. I guess I need to make a table for items received . I was hoping
to avoid that but I see exactly what you are saying.

"TonyT" wrote:

Hi,

You won't be able to with that table design, the best you will get is the
number outstanding. Presumably you increase the qty received and reduce the
qty remaining each time items are booked in?

What would be more efficient, would be to separate the Order table from the
Orders received so that you would have one record for each time items were
booked in the OrdersRecvd table, where you could also record the date/time,
operator doing the booking in etc. You would then calculate the qty remaining
as the difference between the qty ordered and a sum of the qty's received.

Is vendor item # the foreign key to the vendors table? What is the
description describing and what is the delivery status used to record? Are
there any other fields referenced in that form and how many tables does that
info come from?

TonyT

"kms" wrote:

I have a control on my form that my receiving department has to enter the
amount of items that have come in on a particular shipment. I need this
field to start over at 0 after the form is closed but the value that is place
in this field needs to be collected into another field. I'm trying to add up
all of the items that have come in total for a particular order over a period
of time. I have no idea how to make this happen here are my controls on my
form:
vendor item#, description, qty ordered, qty received, qty remaining,
delivery status
Thank you in advance for any ideas.