Hope someone can help with this.
I have a form which lists all my outstanding orders.
Via a Dcount I get a figure of whats in stock for each order (product description & length) & this figure is listed against each parrticular order.(stock Qty)
But what I also want it to do is look at the Qty feild for each order, sum them & subtract it from the total qty in stock & list the outcome against each order. (if there is enough stock to cover order for each line)
Is this possible.
I have attached a sample of DB to give a better understanding of where I am at.
Any help would be great.
I have a form which lists all my outstanding orders.
Via a Dcount I get a figure of whats in stock for each order (product description & length) & this figure is listed against each parrticular order.(stock Qty)
But what I also want it to do is look at the Qty feild for each order, sum them & subtract it from the total qty in stock & list the outcome against each order. (if there is enough stock to cover order for each line)
Is this possible.
I have attached a sample of DB to give a better understanding of where I am at.
Any help would be great.
