Where in the report?
What Datatype is [TissueSent]? Yes/No? Text?
Add 2 unbound controls to the Report Footer section.
Assuming "Yes" or "No" as text datatype:
= Sum(IIf([TissueSent] = "Yes",1,0))
= Sum(IIf([TissueSent] = "No",1,0))
Assuming Yes or No as in a Yes/No field:
=ABS(Sum([TissueSent])) (For Yes)
=Sum([TissueSent]+1) (For No)
Assuming you have a Yes/No field in the detail section.
In the footer, create two text boxes, and set their control sources to:
=Sum(IIf([Test],1,0))
=Sum(IIf(NOT [Test],1,0))
Add appropriate labels.
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.
