straybullet
IS-IT--Management
How would I write this in Access?
=if(and([BDoor_amt]>0,[WLine_amt]>0,[GServDoor_amt]>0,[BICabsBar_amt]>0,[KitBICabs_amt]>0,[FP_amt]>0,[TwoPerWhirlTub_amt]>0,[PDAtticStair_amt]>0),"","None Selected")
This is for a report for which I have already set up the text boxes to "disappear" when there is no value. However, if no selections are made in the section, Id like to display "None Selected" in a text box rather than simply having the section title with no note.
Let them hate - so long as they fear... Lucius Accius
=if(and([BDoor_amt]>0,[WLine_amt]>0,[GServDoor_amt]>0,[BICabsBar_amt]>0,[KitBICabs_amt]>0,[FP_amt]>0,[TwoPerWhirlTub_amt]>0,[PDAtticStair_amt]>0),"","None Selected")
This is for a report for which I have already set up the text boxes to "disappear" when there is no value. However, if no selections are made in the section, Id like to display "None Selected" in a text box rather than simply having the section title with no note.
Let them hate - so long as they fear... Lucius Accius