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.
1 1142
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", "")
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Nathan Bloomfield |
last post by:
Does anyone know if there is any documentation which relates to Access2k + ?
or can anyone help adjust the code?
I am having trouble converting the DAO references.
TITLE :INF: How to...
|
by: Mark Reed |
last post by:
Hi Guru's,
Hopefully I can explain this OK.....What I am trying to do is
create a QC check sheet using the following fields: ASN, PO & Qty. This
information will be at the top of each report with...
|
by: Colin McGuire |
last post by:
Hi, I have an report in Microsoft Access and it displays everything in
the table. One column called "DECISION" in the table has either 1,2,
or 3 in it. On my report it displays 1, 2, or 3. I want...
|
by: Melissa |
last post by:
I created a report that has labels in the top three inches of the page
header. There's also an unbound subform there. When I go to preview or
print, the records from the detail section overlap...
|
by: Melissa |
last post by:
I have a grouped report that starts a new page at each group. All the field
labels for the report are in the group header because there is a subreport
in the top part of the report that needs to...
|
by: MJ |
last post by:
Is it possible to print varying numbers of labels from Access?
|
by: Arnold |
last post by:
Hi Everyone;
In a report, I've essentially recreated a paper sheet by adding various
labels--name, date, problem, year, Progress Notes, etc.--and horizontal
lines (people have traditionally...
|
by: selimzairi |
last post by:
hi to all
would any body help please on this cross table report problem
yrs header -for years grouping
mnt header -for monthes grouping
state_id -for states
columns 1->30 is for branches id;...
|
by: ARC |
last post by:
Hello all,
What's the proper paper size setting if you want to do a receipt printer
report, that's a continuous form? I don't really see an option for a
continuous paper size.
Thanks!
Andy
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |