Counting Formula in Report Footer

C

Curtis

The following is my Conditional Formatting for field [CurrentBMARDate] in the
Detail Section of my report; for any fields that are “empty†or “beyond 1
year of today’s dateâ€. No problem here. Now, in the Report Footer though, I
want to total “a Count†only those that have “empty†and “beyond 1 year of
today’s date†records. I was wondering what would the Control Source text be
like to have this occur! Thanks for any suggestion.

(IsNull([CurrentBMARDate])) Or ([CurrentBMARDate])<DateAdd("yyyy",-1Date())
 
M

Marshall Barton

Curtis said:
The following is my Conditional Formatting for field [CurrentBMARDate] in the
Detail Section of my report; for any fields that are “empty” or “beyond 1
year of today’s date”. No problem here. Now, in the Report Footer though, I
want to total “a Count” only those that have “empty” and “beyond 1 year of
today’s date” records. I was wondering what would the Control Source text be
like to have this occur! Thanks for any suggestion.

(IsNull([CurrentBMARDate])) Or ([CurrentBMARDate])<DateAdd("yyyy",-1Date())
Click to expand...


=Sum(IIf(IsNull([CurrentBMARDate]) Or
[CurrentBMARDate]<DateAdd("yyyy",-1,Date()), 1, 0)
 
C

Curtis

Yes, thanks very much for your expertise. It works! Thank!

Marshall Barton said:
Curtis said:
The following is my Conditional Formatting for field [CurrentBMARDate] in the
Detail Section of my report; for any fields that are “empty†or “beyond 1
year of today’s dateâ€. No problem here. Now, in the Report Footer though, I
want to total “a Count†only those that have “empty†and “beyond 1 year of
today’s date†records. I was wondering what would the Control Source text be
like to have this occur! Thanks for any suggestion.

(IsNull([CurrentBMARDate])) Or ([CurrentBMARDate])<DateAdd("yyyy",-1Date())
Click to expand...


=Sum(IIf(IsNull([CurrentBMARDate]) Or
[CurrentBMARDate]<DateAdd("yyyy",-1,Date()), 1, 0)
Click to expand...
 
Top