D
dogpigfish
I have a range of dates. Basically a paremeter is entered and I want an item
to add according to the dates entered. When a person enters 08/22/05, I want
the report to total all line items for the next 6 days.
For example:
Report for 08/22/05
08/22/05 1.00
08/23/05 2.00
08/25/05 1.00
08/31/05 3.00
Total 08/22/05 through 08/28/05 = 4.00
The equation I am using is =Sum(IIf([GeneratedDate] Between [EnterDate] And
([EnterDate]+6),[Allocate]))
Any equation that would work?
to add according to the dates entered. When a person enters 08/22/05, I want
the report to total all line items for the next 6 days.
For example:
Report for 08/22/05
08/22/05 1.00
08/23/05 2.00
08/25/05 1.00
08/31/05 3.00
Total 08/22/05 through 08/28/05 = 4.00
The equation I am using is =Sum(IIf([GeneratedDate] Between [EnterDate] And
([EnterDate]+6),[Allocate]))
Any equation that would work?