michaelorlowski
Technical User
How can you get a value from data that uses a yes/no data type where there are total numbers of yes and no?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Adding totals of yes/no fields
- Thread starter michaelorlowski
- Start date
- Status
Michael,
You can take the Yes/No field and put it in a group by query setting the group by option to be count and then setting the criteria for which option you want the count on.
The other option would be to use the Dcount function.
HTH,
Steve
You can take the Yes/No field and put it in a group by query setting the group by option to be count and then setting the criteria for which option you want the count on.
The other option would be to use the Dcount function.
HTH,
Steve
threeunderpar
Programmer
Create an unbound field on your form or report with a calculation in its control source.
In the control source enter:
=iif([NameofYesNoField]="Yes",1,0)
Hope this helps you.
In the control source enter:
=iif([NameofYesNoField]="Yes",1,0)
Hope this helps you.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question