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!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Counting Boolean fields 1

Status
Not open for further replies.
colkas

colkas

IS-IT--Management
Aug 26, 2003
39
SE
I want to count boolean fields in a report but only count the Yes . Any ideas how I can achieve this.

Thanks
 
Sort by date Sort by votes
Try the following as control source of a textbox:

[tt]=ABS(Sum([NameOfField]))[/tt]

Roy-Vidar
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

atadbitslow
  • Locked
  • Question
comparing fields, one populated with data and one blank 2
Replies
8
Views
786
atadbitslow
atadbitslow
BallunarCrew
  • Locked
  • Question
Can I map fields when connecting to SQL Server thru ODBC? 1
Replies
1
Views
224
dhookom
dhookom
kentover
  • Locked
  • Question
MS Access Linked to SQL Server Numeric Fields Lose Precision and Scale 1
Replies
7
Views
503
kentover
kentover
Paul_W
  • Locked
  • Question
Access query calculated fields not exporting to excel 1
Replies
8
Views
399
Paul_W
Paul_W
weightinwildcat
  • Locked
  • Question
Count of columns/fields in a query or table.
Replies
1
Views
190
MajP
MajP

Part and Inventory Search

Sponsor

Back
Top