N
naveen prasad
Hi all,
Kindly solve my problem.
I have 2 tables stock_received , stock_utilized.
stock_received fields -- date,3pcs,4pcs,boxes.
stock_utilized fields -- date,3pcs,4pcs,boxes.
I have successfully made a query to get the the current stock in hand as
select sum(3pcs)- dsum("3pcs","stock_utilized"),
sum(4pcs)-dsum("4pcs","stock_utilized"),sum(boxes)-dsum("boxes","stock_utilized") from stock_received ;
Here i have a complex problem, I cant make query with date criteria.
for example 01/05/2010 to 30/05/2010
I want to get how much stock received in that dates and how much was
utilized and how much is balance.
kindly help me how should i write query.
Kindly solve my problem.
I have 2 tables stock_received , stock_utilized.
stock_received fields -- date,3pcs,4pcs,boxes.
stock_utilized fields -- date,3pcs,4pcs,boxes.
I have successfully made a query to get the the current stock in hand as
select sum(3pcs)- dsum("3pcs","stock_utilized"),
sum(4pcs)-dsum("4pcs","stock_utilized"),sum(boxes)-dsum("boxes","stock_utilized") from stock_received ;
Here i have a complex problem, I cant make query with date criteria.
for example 01/05/2010 to 30/05/2010
I want to get how much stock received in that dates and how much was
utilized and how much is balance.
kindly help me how should i write query.