Dsum Expression

A

Andy

Ken Snell

Thank you for Replying me

Question was I need to do Accumulated sum in ToDateQty Field from
ToDay's Qty field.

Example:

date Lot # SubLot# ToDay'sQty ToDateQty
03/27/07 1 1 500 500
03/27/07 1 2 500 1000
03/27/07 1 3 300 1300

03/28/07 1 3 200 1500
03/28/07 1 4 500 2000 and so
on...
I tried on Report with Running Sum which works good But I cannot use this
field in other calculated Field in this report. So I would like to have Query
for ToDaDateQty field. I think DSum will work but I don't know how?

Andy
 
M

Marshall Barton

Andy said:
Ken Snell

Thank you for Replying me

Question was I need to do Accumulated sum in ToDateQty Field from
ToDay's Qty field.

Example:

date Lot # SubLot# ToDay'sQty ToDateQty
03/27/07 1 1 500 500
03/27/07 1 2 500 1000
03/27/07 1 3 300 1300

03/28/07 1 3 200 1500
03/28/07 1 4 500 2000 and so
on...
I tried on Report with Running Sum which works good But I cannot use this
field in other calculated Field in this report. So I would like to have Query
for ToDaDateQty field. I think DSum will work but I don't know how?


Why can;t you use the running sum text box in other
calculations?

The DSum would be something like this air code:

DSum("[ToDay'sQty]", "the table", "([date] < " &
Format([date], "\#m\/d\/yyyy\#") & ") OR ([date] = " &
Format([date], "\#m\/d\/yyyy\#") & " And [SubLot#] <= " &
[SubLot#]))

You don't really have a field named Date do you? Date is
the name of a function that returns the date the query is
executed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DSumExpression 2
DSUM Expression 1
Running Balance (Debit and Credit) in Access 2007 3
Running Sum 9
Autofilter problem 9
Reverse Index Match 2
Running sum 3
Date parameter 3

Top