Dsum Expression

[Guest]

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

 

[Marshall Barton]

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.