Counting Formula in Report Footer

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Curtis - 24 May 2006 18:14 GMT

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

Reply to this Message

Marshall Barton - 24 May 2006 18:45 GMT

>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
[quoted text clipped - 4 lines]
>
>(IsNull([CurrentBMARDate])) Or ([CurrentBMARDate])<DateAdd("yyyy",-1Date())

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

Signature

Marsh
MVP [MS Access]

Reply to this Message

Curtis - 24 May 2006 19:27 GMT

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
[quoted text clipped - 7 lines]
> =Sum(IIf(IsNull([CurrentBMARDate]) Or
> [CurrentBMARDate]<DateAdd("yyyy",-1,Date()), 1, 0)

Reply to this Message