P
PMJ
Hi All,
Here is my problem:
I have a database with orders, order details and tblproduction. What i want
to do is the following:
Get a query to collect information from order details sorted by productID
and also information from the tblproduction table by productid and use the
end results into a form. What i want to do is get information from the order
details for sold quantities, quantities from tblproduction as far as
produced quantity and get the closing stock. Am i getting confused in the
whole issue or is there a simple way to tackle the problem.
Please help, my boss is putting lots of pressure on me.
Thanks to all
JM
Here is my problem:
I have a database with orders, order details and tblproduction. What i want
to do is the following:
Get a query to collect information from order details sorted by productID
and also information from the tblproduction table by productid and use the
end results into a form. What i want to do is get information from the order
details for sold quantities, quantities from tblproduction as far as
produced quantity and get the closing stock. Am i getting confused in the
whole issue or is there a simple way to tackle the problem.
Please help, my boss is putting lots of pressure on me.
Thanks to all
JM