I have created a pretty basic database, more or less self taught after an MS Office overview course for MS 2007. There is a field with a "calculated" data type, with the expression put in that adds a couple of other columns in the table together. I am not getting syntax error messages on the expression, but in the table and reports, the calculated data field is blank if I do not populate the columns with a 0 when not applicable.
Can anyone tell me how to get the total to show up when not all columns apply to the equation?
For clarification, my calculated column for "Gross Tuition" is tuition + 5-day room and board + 7-day room and board - tuition adjustments - scholarships......not all records have one or either board or adjustments and/or scholarships. When these fields are blank, the assumption is they are =0. Is this just a syntax issue? If so, please help.
Thank you.