435,376 Members | 3,024 Online
Need help? Post your question and get tips & solutions from a community of 435,376 IT Pros & Developers. It's quick & easy.

# Access 2003 - math question in a report

 P: 7 I have a database that is using a checkbox for item complete. On a summary report i need it to add up the number of check boxes and place a number (total number of checks that occur) in this spot. Sounds easy, but i cannot figure out how to do it! Thanks Chris Dec 14 '07 #1
6 Replies

 Expert 2.5K+ P: 3,532 First understand that I very seldom have to do this kind of thing in a report and there's probably a much more elegant way of doing this, but this worked when I ran up a mockup of this. Place an unbound textbox on the form in your footer and enter this as its ControlSource: Expand|Select|Wrap|Line Numbers =Abs(DSum("[YourCheckBox]","YourTable/QueryName")) Welcome to TheScripts! Linq ;0)> Dec 14 '07 #2

 P: 7 Works Perfectly! THANKS!! First understand that I very seldom have to do this kind of thing in a report and there's probably a much more elegant way of doing this, but this worked when I ran up a mockup of this. Place an unbound textbox on the form in your footer and enter this as its ControlSource: Expand|Select|Wrap|Line Numbers =Abs(DSum("[YourCheckBox]","YourTable/QueryName")) Welcome to TheScripts! Linq ;0)> Dec 17 '07 #3

 Expert 2.5K+ P: 3,532 Glad we could help! Linq ;0)> Dec 17 '07 #4

 P: 7 One Step Further..... using this same logic I have designed a report page for all my tally's. How can I make this work? Expand|Select|Wrap|Line Numbers                  =Abs(DSum("[Field='UNIX']","YourTable/QueryName"))   In a different text box: Expand|Select|Wrap|Line Numbers                  =Abs(DSum("[Field='MAINFRAME']","YourTable/QueryName"))   I have attempted several methods with no success. "I am not a Dba and I do not play one on T.V.!" ;) Dec 17 '07 #5

 P: 7 OK, so what I have done so far is create a Query that holds only the OSFlag field of the Table, and the Criteria is "U". This Query contains 51 rows. I would like to put this number (51) into a tally report. There are 38 Tally's that can be pulled from 38 Query's. All of the Query's dod what they are supposed to do, but my problem is that the report calle dthe TALLY REPORT needs to contain only the number of rows in each Query. HELP!! Chris One Step Further..... using this same logic I have designed a report page for all my tally's. How can I make this work? Expand|Select|Wrap|Line Numbers                  =Abs(DSum("[Field='UNIX']","YourTable/QueryName"))   In a different text box: Expand|Select|Wrap|Line Numbers                  =Abs(DSum("[Field='MAINFRAME']","YourTable/QueryName"))   I have attempted several methods with no success. "I am not a Dba and I do not play one on T.V.!" ;) Dec 18 '07 #6

 P: 7 Guess what? I have been messing with the DCount for so long that I accedentially figured it out. It was just a matter of proper placement of the field and Query name. Almost like real programming! :) Expand|Select|Wrap|Line Numbers =DCount("[OSFlag]","QU")   This is what i ended up with and it works like I need it to work. It pulls in the Query and counts the rows. There are 38 Query's, and now in my Summary doc i have 38 fields. All I need to figure out now is how to email this document (as a PFD if possible) to the department. Always the same email addresses, always at the same time each day. Thanks for the direction! Dec 18 '07 #7