Qty Remaining

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Malfunction - 15 Apr 2006 01:04 GMT

I have a table called Bill of Materials with the fields Qty In and Qty
Remaining.
I have another table called Materials issued with a field Qty issued. (book
items to a Job No)
i would like to know if i can get access to automaticaly fill the Qty
Remaining field by subracting the Qty issued from the Qty in and to update
this field as items are booked out.

Thanks heaps

Malfunction

Reply to this Message

Jeff Boyce - 17 Apr 2006 23:43 GMT

If your table structure already has a place to store the number of items
added (?QtyIn) and the number of items used (?QtyIssued), then why store the
calculated difference? It is rarely necessary to do so, and doing so adds
complexity and extra work for both you and Access.

Instead, consider a query (or a combination of queries) total up the out-go,
then subtract that from the in-flow.

Regards

Jeff Boyce
Microsoft Office/Access MVP

>I have a table called Bill of Materials with the fields Qty In and Qty
> Remaining.
[quoted text clipped - 8 lines]
>
> Malfunction

Reply to this Message

Malfunction - 18 Apr 2006 08:36 GMT

>If your table structure already has a place to store the number of items
>added (?QtyIn) and the number of items used (?QtyIssued), then why store the
[quoted text clipped - 14 lines]
>>
>> Malfunction

Hi Jeff,
Thanks, the reason i want to store the calculated difference is because the
records in the Bill of Materials tables contains fields for chemical and
mechanical analysis
when the total of the specified Batch of stock is 0 i can filty or queery out
but still keep the records for tracability.
In my business we have many of the same items as in a store type stock but i
have to trace my stock by the batch No. and i need to be able to trace the
Batch

Signature

Malfunction

Reply to this Message