I have a Query with 5 insurance amounts ( Cancer, Accidental, Group, Short Term, and Sick). I am wanting to create another column that adds all 5 of these and put the total in that column. I know you can do it with the expression-
Total : [Cancer_Ammount]+[Accident_Ammount]+[ShortTermDis_Ammount]+[PersonalSick_Ammount]+[GroupTerm_Ammount]
The expression works only if all 5 columns have values. Not everyone has all of these so some columns contain Null values. I think that is were my problem is. The expression will not add a Null value and thus will leave no information in the Total column it creates.