Hi
I have
Form-1 - Which stores New Orders with total quantity
Form -2 - Trip Master - Used to allocate vehicles to dispatch the orders
under form 2 another subform which actually has the Order Number and the quantity dispatched
Now i need to populate a report which shows total quantity and Quantity Dispatched and Pending Quantity of that order
I have actually created a report with Form-1 and have order id and Tot-Qty Recd.But now i need to display what is the pending qty to be dispatched.
Stuck here!
Have attached the image.
Kindly help