J
jkirk
I currently have a database that contains a form for entering tooling
numbers as well as the copy number of the tooling, and Qty. of tooling if the
copy number is N/A. The form also has a drop down for selecting "Incoming"
or "Outgoing". My problem is now I am wanting to start an inventory query and
want to show the "Incoming" tooling as on hand inventory and also view the
Qty. as well for N/A copy tooling. Some of this tooling is "Incoming" and
"Outgoing" many times so I started a query that displays Tooling with copy
numbers and "Incoming" as their most recent status as in inventory. My
problem is working with the tooling that is N/A and has a Qty. I would like
to add the Qty. when it is "Incoming" and have it subtract from the Qty. when
it is "Outgoing" and list it in my inventory query.
numbers as well as the copy number of the tooling, and Qty. of tooling if the
copy number is N/A. The form also has a drop down for selecting "Incoming"
or "Outgoing". My problem is now I am wanting to start an inventory query and
want to show the "Incoming" tooling as on hand inventory and also view the
Qty. as well for N/A copy tooling. Some of this tooling is "Incoming" and
"Outgoing" many times so I started a query that displays Tooling with copy
numbers and "Incoming" as their most recent status as in inventory. My
problem is working with the tooling that is N/A and has a Qty. I would like
to add the Qty. when it is "Incoming" and have it subtract from the Qty. when
it is "Outgoing" and list it in my inventory query.