i have defined "Quantity" and "toatl cost" in one table and "issued qty" in other table... nw i wanna find the rate of item... whih will be cost/qty wich is in 2 diff tables? how to do this?
i have defined "Quantity" and "toatl cost" in one table and "issued qty" in other table... nw i wanna find the rate of item... whih will be cost/qty wich is in 2 diff tables? how to do this?
I want to say a query but without knowing how these tables relate to each other not sure it can be done that way. It would help if you post the table details and how they relate to each other...