Counting Checkboxes

  • Thread starter Thread starter Max
  • Start date Start date
M

Max

Hello,

I have a report that calculates outstanding records.

I am calculating =(Count([To A/E])-(Count([From A/E]))- (
Count([Inhouse only]))). The [Inhouse only] is a check
box and I want to subtract only those records that are
checked.

I tried - Count([Inhouse only]="-1"))), but nothing.

Any ideas. Many many thanks in advance.
Max
 
Try:
=(Count([To A/E])-(Count([From A/E]))- ( Sum(Abs([Inhouse only]))))
 
You must log in or register to reply here.

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

counting records 0
Count of records where checkbox 1 is unchecked, checkbox 2 is chec 1
Access Dcount function in access 0
Counting Records in report footer 4
The death of music TV channels in UK - but not Europe? 4
Count, Fields Calucation help 0
Counting Unique Values within a Group 2
Report Sum/If Statement 2

Back
Top