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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Count Field on report if checkbox = true

Status
Not open for further replies.
fredk

fredk

Technical User
Jul 26, 2001
708
US
I have a report where I want to show the detail but I also want to have a field that only totals the groups that have a specific checkbox (named "complete) selected - I was thinking I would put some code in the onprint event but am lost?

Any help would be greatly appreciated!!!!

Fred


 
Sort by date Sort by votes
Sorry, I figured it out - ABS function.

Thanks!

Fred
 
Upvote 0 Downvote
ABS()???

=DSum("txtTotal","tblReport","chkComplete = True")
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

V
  • Locked
  • Helpful tip
Capture Shift Key if Pressed on A form
Replies
3
Views
463
strongm
strongm
JimStrand
  • Locked
  • Question
Using Report Header (Form control) as Variable in Report Expression 1
Replies
11
Views
1K
dhookom
dhookom
bobbyer
  • Locked
  • Question
ms accesss option group on report
Replies
4
Views
241
bobbyer
bobbyer
renigar
  • Locked
  • Question
Code to write file path to field always writes to 1st record 1
Replies
5
Views
525
dhookom
dhookom
Johnny S
  • Locked
  • Question
Create folder based on ID field MS Access
Replies
3
Views
266
MattGreer
MattGreer

Part and Inventory Search

Sponsor

Back
Top