M
Michael Fenton
Here's the story. I need a query that will remove
product from an itemized inventory list. For example. I
have 10 widgets listed in an order that I received 2
weeks ago at $5.00 each. I have another 15 widgets that
were reveived 2 days ago @ $5.25 each. If someone orders
12 widgets, I want the query to remove 10 widgets from
the first order from two weeks ago at the price of $5.00
and 2 from the order I received 2 days ago at the price
of $5.25 each. How would I make an update query to
handle this?? PLEASE HELP. My brain hurts.
product from an itemized inventory list. For example. I
have 10 widgets listed in an order that I received 2
weeks ago at $5.00 each. I have another 15 widgets that
were reveived 2 days ago @ $5.25 each. If someone orders
12 widgets, I want the query to remove 10 widgets from
the first order from two weeks ago at the price of $5.00
and 2 from the order I received 2 days ago at the price
of $5.25 each. How would I make an update query to
handle this?? PLEASE HELP. My brain hurts.