Running sum

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

friends,
Q.1: I have table "HMADetail" That has fields as

Date Lot# SubLot# HMAPlacedToDay HMAPlacedToDate .......
(1) (2) (3) (4) (5)

I Have not created Query table from this table but created report with
fields (4) and (5) same. I set property for Field (5) with Running Sum
Overall. This report works good. But it writs all records from begining date
to end date. I onlt need end date records. How do I get this without query
table?

Q2: If I have to creat query table then in calculatd fild (5) what should I
write?

I tride with HMAPlacedToDay:
DSum("HMAPlacedToDay","HMADetail","[Lot#],SubLot#]="&[Lot#]&[SubLot#]

This doesn't work.
Andy
 
Back
Top