If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sum Iff Function
I'm trying to use an Iif function between two columns that are populated in
the db. The lines total across, but when I try to grand total them att he bottom, I get asked for more information or get an error. =Sum(IIf([Monthly Limit][Total Points],[Total Points],[Monthly Limit])) |
#2
|
|||
|
|||
Sum Iff Function
What error?
What are you asked for? Where is this code? More detail makes it easier to help with an answer. -- Dave Hargis, Microsoft Access MVP "Hagan" wrote: I'm trying to use an Iif function between two columns that are populated in the db. The lines total across, but when I try to grand total them att he bottom, I get asked for more information or get an error. =Sum(IIf([Monthly Limit][Total Points],[Total Points],[Monthly Limit])) |
#3
|
|||
|
|||
Sum Iff Function
There is no actual error, I'm just asked to supply the Monthly Limit and the
Total Points, but I can't as each item has a different points value and a different monthly limit. "Klatuu" wrote: What error? What are you asked for? Where is this code? More detail makes it easier to help with an answer. -- Dave Hargis, Microsoft Access MVP "Hagan" wrote: I'm trying to use an Iif function between two columns that are populated in the db. The lines total across, but when I try to grand total them att he bottom, I get asked for more information or get an error. =Sum(IIf([Monthly Limit][Total Points],[Total Points],[Monthly Limit])) |
#4
|
|||
|
|||
Sum Iff Function
Okay, so where is the code and what are Monthly Limit and Total Points?
-- Dave Hargis, Microsoft Access MVP "Hagan" wrote: There is no actual error, I'm just asked to supply the Monthly Limit and the Total Points, but I can't as each item has a different points value and a different monthly limit. "Klatuu" wrote: What error? What are you asked for? Where is this code? More detail makes it easier to help with an answer. -- Dave Hargis, Microsoft Access MVP "Hagan" wrote: I'm trying to use an Iif function between two columns that are populated in the db. The lines total across, but when I try to grand total them att he bottom, I get asked for more information or get an error. =Sum(IIf([Monthly Limit][Total Points],[Total Points],[Monthly Limit])) |
#5
|
|||
|
|||
Sum Iff Function
The monthly limit and total points are in a table in the db. I'm not sure
where to get the code. I just can't get it to grand total. "Hagan" wrote: There is no actual error, I'm just asked to supply the Monthly Limit and the Total Points, but I can't as each item has a different points value and a different monthly limit. "Klatuu" wrote: What error? What are you asked for? Where is this code? More detail makes it easier to help with an answer. -- Dave Hargis, Microsoft Access MVP "Hagan" wrote: I'm trying to use an Iif function between two columns that are populated in the db. The lines total across, but when I try to grand total them att he bottom, I get asked for more information or get an error. =Sum(IIf([Monthly Limit][Total Points],[Total Points],[Monthly Limit])) |
#6
|
|||
|
|||
Sum Iff Function
The Iif statement you posted. Is it in a query, a form, on a report, in VBA
code, A macro? -- Dave Hargis, Microsoft Access MVP "Hagan" wrote: The monthly limit and total points are in a table in the db. I'm not sure where to get the code. I just can't get it to grand total. "Hagan" wrote: There is no actual error, I'm just asked to supply the Monthly Limit and the Total Points, but I can't as each item has a different points value and a different monthly limit. "Klatuu" wrote: What error? What are you asked for? Where is this code? More detail makes it easier to help with an answer. -- Dave Hargis, Microsoft Access MVP "Hagan" wrote: I'm trying to use an Iif function between two columns that are populated in the db. The lines total across, but when I try to grand total them att he bottom, I get asked for more information or get an error. =Sum(IIf([Monthly Limit][Total Points],[Total Points],[Monthly Limit])) |
#7
|
|||
|
|||
Sum Iff Function
In a report.
"Klatuu" wrote: The Iif statement you posted. Is it in a query, a form, on a report, in VBA code, A macro? -- Dave Hargis, Microsoft Access MVP "Hagan" wrote: The monthly limit and total points are in a table in the db. I'm not sure where to get the code. I just can't get it to grand total. "Hagan" wrote: There is no actual error, I'm just asked to supply the Monthly Limit and the Total Points, but I can't as each item has a different points value and a different monthly limit. "Klatuu" wrote: What error? What are you asked for? Where is this code? More detail makes it easier to help with an answer. -- Dave Hargis, Microsoft Access MVP "Hagan" wrote: I'm trying to use an Iif function between two columns that are populated in the db. The lines total across, but when I try to grand total them att he bottom, I get asked for more information or get an error. =Sum(IIf([Monthly Limit][Total Points],[Total Points],[Monthly Limit])) |
#8
|
|||
|
|||
Sum Iff Function
Okay. First Total Points and Monthly Limit must be fields in the report's
record source. The expression you are using appears to be valid, so that is the only thing I can think of that would cause it to ask you to enter them. If you have controls on your report with the same name, you should rename them so the report wont get confused. -- Dave Hargis, Microsoft Access MVP "Hagan" wrote: In a report. "Klatuu" wrote: The Iif statement you posted. Is it in a query, a form, on a report, in VBA code, A macro? -- Dave Hargis, Microsoft Access MVP "Hagan" wrote: The monthly limit and total points are in a table in the db. I'm not sure where to get the code. I just can't get it to grand total. "Hagan" wrote: There is no actual error, I'm just asked to supply the Monthly Limit and the Total Points, but I can't as each item has a different points value and a different monthly limit. "Klatuu" wrote: What error? What are you asked for? Where is this code? More detail makes it easier to help with an answer. -- Dave Hargis, Microsoft Access MVP "Hagan" wrote: I'm trying to use an Iif function between two columns that are populated in the db. The lines total across, but when I try to grand total them att he bottom, I get asked for more information or get an error. =Sum(IIf([Monthly Limit][Total Points],[Total Points],[Monthly Limit])) |
#9
|
|||
|
|||
Sum Iff Function
I think you may have found the error. Thanks for the help, I'll let you know
if it works. "Klatuu" wrote: Okay. First Total Points and Monthly Limit must be fields in the report's record source. The expression you are using appears to be valid, so that is the only thing I can think of that would cause it to ask you to enter them. If you have controls on your report with the same name, you should rename them so the report wont get confused. -- Dave Hargis, Microsoft Access MVP "Hagan" wrote: In a report. "Klatuu" wrote: The Iif statement you posted. Is it in a query, a form, on a report, in VBA code, A macro? -- Dave Hargis, Microsoft Access MVP "Hagan" wrote: The monthly limit and total points are in a table in the db. I'm not sure where to get the code. I just can't get it to grand total. "Hagan" wrote: There is no actual error, I'm just asked to supply the Monthly Limit and the Total Points, but I can't as each item has a different points value and a different monthly limit. "Klatuu" wrote: What error? What are you asked for? Where is this code? More detail makes it easier to help with an answer. -- Dave Hargis, Microsoft Access MVP "Hagan" wrote: I'm trying to use an Iif function between two columns that are populated in the db. The lines total across, but when I try to grand total them att he bottom, I get asked for more information or get an error. =Sum(IIf([Monthly Limit][Total Points],[Total Points],[Monthly Limit])) |
Thread Tools | |
Display Modes | |
|
|