F fredg Jul 1, 2005 #2 How do I sum records that fall within a specific date range in a report Click to expand... And what determines the specific date range? In the Report Footer: =Sum(IIf([DateField] Between #1/1/2005# and #6/30/2005#,[NumberField],0) will sum your Number field for the 6 month period.
How do I sum records that fall within a specific date range in a report Click to expand... And what determines the specific date range? In the Report Footer: =Sum(IIf([DateField] Between #1/1/2005# and #6/30/2005#,[NumberField],0) will sum your Number field for the 6 month period.
