A
Andy
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
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