Unanswered: =Sum((IIf.......how to make textbox 0 if nothing
I have a continuous form that displays a list of reservations, waitlist, and cancelled. And the list does not allow additions. Can only add a reservation by a command button.
I have a textbox that displays the total # of reservations by the control source
=Sum(IIf([status]="Reserved" , 1, 0))
If I open a list that has no information or no one has called to reserve, cancel, or waitlist, i want to be able to have my total # of reservations to display 0 instead of blank or Null. Pretty much I would like my textbox to have a value no matter what.
Anyway I can do this?