Counting Formula in Report Footer

[Guest]

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())

 

[Marshall Barton]

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())

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

 

[Guest]

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

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())

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