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
|
|||
|
|||
IIf function help please
Hi
I have a Totals column in a report that adds a Points and Bonus Points field using =Nz([Points],0)+Nz([Bonus Points],0) I would like to modify this so that if [Bonus Points] is empty (Null I guess? - there would be no value at all) then the Total is left blank I.E. 'If Bonus Points is blank, then Total is blank, else Points + Bonus Points" Struggling with my IIf statement, and would appreciate some guidance Thanks Neil |
#2
|
|||
|
|||
IIf function help please
On 17 Apr, 00:49, "
wrote: Hi I have a Totals column in a report that adds a Points and Bonus Points field using =Nz([Points],0)+Nz([Bonus Points],0) I would like to modify this so that if [Bonus Points] is empty (Null I guess? - there would be no value at all) then the Total is left blank I.E. *'If Bonus Points is blank, then Total is blank, else Points + Bonus Points" Struggling with my IIf statement, and would appreciate some guidance Thanks Neil Figured it! Neil |
#3
|
|||
|
|||
IIf function help please
|
#4
|
|||
|
|||
IIf function help please
Simplest solution is
=Nz([Points],0)+[Bonus Points] That will return Null if Bonus points is null. In all other cases it will return a result. So if Bonus Points is zero (and not null) you will see the value of Points or zero if Points is null. John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County wrote: Hi I have a Totals column in a report that adds a Points and Bonus Points field using =Nz([Points],0)+Nz([Bonus Points],0) I would like to modify this so that if [Bonus Points] is empty (Null I guess? - there would be no value at all) then the Total is left blank I.E. 'If Bonus Points is blank, then Total is blank, else Points + Bonus Points" Struggling with my IIf statement, and would appreciate some guidance Thanks Neil |
Thread Tools | |
Display Modes | |
|
|