K
Kelly Enright
Hi again: In my "Date Footer" I have the following
Bag Changes for the Month =Count(*)+Sum([Expr1])
In my "Report Footer" I have the same entry. This works
fine as it picks up all of the bag changes YTD. My problem
is that I need a way for "Bag Changes for the Month" to
show the record count when there are no entries in the
[Expr1] field.
Example1:
Date RowNumber SectorNumber
Total Bag Changes for the Month 11 (This works well)
Example2:
Date RowNumber SectorNumber
Total Bag Changes for the Month 1 (This will not show on
the report but is included in the YTD totals in
the "Report Footer" which would show 12).
You have all been a great help and I thank you very much.
Compliments of the season to all...kbe
Bag Changes for the Month =Count(*)+Sum([Expr1])
In my "Report Footer" I have the same entry. This works
fine as it picks up all of the bag changes YTD. My problem
is that I need a way for "Bag Changes for the Month" to
show the record count when there are no entries in the
[Expr1] field.
Example1:
Date RowNumber SectorNumber
Total Bag Changes for the Month 11 (This works well)
Example2:
Date RowNumber SectorNumber
Total Bag Changes for the Month 1 (This will not show on
the report but is included in the YTD totals in
the "Report Footer" which would show 12).
You have all been a great help and I thank you very much.
Compliments of the season to all...kbe