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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summing in a Report Footer 7
Check box on form that make the Sum in report footer 5
My query Sum on report footer. 1
sum of check box 2
Sum unique entries in report footer 2
A03 - count in report footer gives me #Error? 0
SUM IN REPORT FOOTER? 3
Sum Check Box 5

Top