By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,376 Members | 3,024 Online
Bytes IT Community
+ Ask a Question
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

CougarMutt
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
Share this Question
Share on Google+
6 Replies


missinglinq
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
  1. =Abs(DSum("[YourCheckBox]","YourTable/QueryName"))
Welcome to TheScripts!

Linq ;0)>
Dec 14 '07 #2

CougarMutt
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
  1. =Abs(DSum("[YourCheckBox]","YourTable/QueryName"))
Welcome to TheScripts!

Linq ;0)>
Dec 17 '07 #3

missinglinq
Expert 2.5K+
P: 3,532
Glad we could help!

Linq ;0)>
Dec 17 '07 #4

CougarMutt
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
  1.                  =Abs(DSum("[Field='UNIX']","YourTable/QueryName"))
  2.  
In a different text box:
Expand|Select|Wrap|Line Numbers
  1.                  =Abs(DSum("[Field='MAINFRAME']","YourTable/QueryName"))
  2.  
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

CougarMutt
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
  1.                  =Abs(DSum("[Field='UNIX']","YourTable/QueryName"))
  2.  
In a different text box:
Expand|Select|Wrap|Line Numbers
  1.                  =Abs(DSum("[Field='MAINFRAME']","YourTable/QueryName"))
  2.  
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

CougarMutt
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
  1. =DCount("[OSFlag]","QU")
  2.  
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

Post your reply

Sign in to post your reply or Sign up for a free account.