YES/NO check box=false show sum in report footer

  • Thread starter Frederic via AccessMonster.com
  • Start date
F

Frederic via AccessMonster.com

I have a YES/NO check box called 'merchandisereceived" on my form. How can I
have the sum of the ones that = False
(merchandise received) in my report footer.

Presently, my sum's are coming from my queries. What should I modified

Any suggestions?

Thanking you in advance,
 
S

Steve Schapel

Frederic,

Assuming you are calculating the sum of a field named Amount, the
expression in ther Control Source of an unbound textbox in the Report
Footer would be like this:
=Sum(IIf([merchandisereceived]=0,[Amount],0))
 
Top