By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,117 Members | 1,093 Online
Bytes IT Community
+ Ask a Question
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
Share this Question
Share on Google+
9 Replies


MMcCarthy
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
  1. =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

MMcCarthy
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
  1. =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
  1. =Sum(IIf([Past Due]>0,1,0))
Mar 14 '07 #6

NeoPa
Expert Mod 15k+
P: 31,473
Sorry it was missing a closing bracket at the end. Should have been

Expand|Select|Wrap|Line Numbers
  1. =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

MMcCarthy
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

NeoPa
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

MMcCarthy
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

Post your reply

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