View Single Post
  #1  
Old June 7th, 2010, 11:16 AM posted to microsoft.public.access.queries
naveen prasad[_2_]
external usenet poster
 
Posts: 80
Default Dsum Problem with date criteria

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.