432,117 Members | 1,093 Online
Need help? Post your question and get tips & solutions from a community of 432,117 IT Pros & Developers. It's quick & easy.

# Report totals records that have data in field

 P: 14 I want to be able to count all records in a report that if the field is greater than 0 it will total it. Example: 5 records are on the report, two of the records in the field Past Due have a number greater than zero. I want only those two record counted in the column. Mar 13 '07 #1
9 Replies

 Expert Mod 10K+ P: 14,534 I want to be able to count all records in a report that if the field is greater than 0 it will total it. Example: 5 records are on the report, two of the records in the field Past Due have a number greater than zero. I want only those two record counted in the column. Try this .. Put a textbox in the report footer, and then put the following code in the Control Source. Expand|Select|Wrap|Line Numbers =Sum(IIf([Past Due]>0,1,0) Mary Mar 13 '07 #2

 P: 14 Mary When I enter as you said, I get this message The expression that you entered is missing a closing parenthesis, bracket(]), or vertical Bar. As ideas Thanks Mickie Mar 13 '07 #3

 P: 14 Mary, Sorry forgot a ) but still not getting the correct data. Mar 13 '07 #4

 P: 14 Mary, Tweeked it a little bit and was able to get it. Couldn't of done it without you. Thanks Mickie Mar 13 '07 #5

 Expert Mod 10K+ P: 14,534 Try this .. Put a textbox in the report footer, and then put the following code in the Control Source. Expand|Select|Wrap|Line Numbers =Sum(IIf([Past Due]>0,1,0) Mary Sorry it was missing a closing bracket at the end. Should have been Expand|Select|Wrap|Line Numbers =Sum(IIf([Past Due]>0,1,0)) Mar 14 '07 #6

 Expert Mod 15k+ P: 31,473 Sorry it was missing a closing bracket at the end. Should have been Expand|Select|Wrap|Line Numbers =Sum(IIf([Past Due]>0,1,0)) This is actually a very clever, and oft used, ploy on her part, to encourage the OP to be involved in solving their own problems. I've seen so many of her posts and you'd be surprised how many little erorors there are around, just to help the OPs to learn ;) Mar 15 '07 #7

 Expert Mod 10K+ P: 14,534 This is actually a very clever, and oft used, ploy on her part, to encourage the OP to be involved in solving their own problems. I've seen so many of her posts and you'd be surprised how many little erorors there are around, just to help the OPs to learn ;) Watch it Ade :) Mar 15 '07 #8

 Expert Mod 15k+ P: 31,473 This is actually a very clever, and oft used, ploy on her part, to encourage the OP to be involved in solving their own problems. I've seen so many of her posts and you'd be surprised how many little erorors there are around, just to help the OPs to learn ;) Watch it Ade :) And there was I, just lauding you to the hills... Harsh (and suspicious I'd say ;)). Mar 16 '07 #9

 Expert Mod 10K+ P: 14,534 And there was I, just lauding you to the hills... Harsh (and suspicious I'd say ;)). I just know YOU! Mar 16 '07 #10