By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 2,596 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Sifting out 2 indentifying numbers in a report detail for labels to a sum

P: 17
I have a tricky problem. I have a report that contains information about amounts paid for service and they have a RANumber that on each line with the amount. Then in the invoice header I am showing a text box with the total values for each of two RANumbers. I am getting the Sum of each of the two RANumbers just fine with:

RA1Sum :=Sum(IIf([NPI]<>1780694984,0,[TotalPaid]))
RA2Sum:=Sum(IIf([NPI]<>1649307471,0,[TotalPaid]))

Now the problem: I have another textbox to act as a label for each sum. The RANumber has to show for the RA1 and Show the RANumber for RA2. I tried this:
RA1 Label: =IIf([NPI]<>1780694984,"",[RANum])
RA2 Label: =IIf([NPI]<>1649307471,"",[RANum])

This works fine if I only have values for one RANumber in the detail. But as soon as I have 2 then I get the Sum of the values for both, but I only get the label for the first RANumber, but the label for the second does not show up. I hope soomeone can understand what I am trying to do. I am stuck.
Dec 5 '08 #1
Share this Question
Share on Google+
1 Reply


puppydogbuddy
Expert 100+
P: 1,923
I am assuming you have only two RANumbers and they are 1780694984 And1649307471. If that is the case, this should work:

RA1 Label: IIf(RA1Sum > 0, "RANumber 1780694984", "")
RA2 Label: IIf(RA2Sum > 0, "RANumber 1649307471", "")
Dec 7 '08 #2

Post your reply

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