var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Sum Across Columns
I have a table in column one is the date and each other column is a day in the week, in each cell is a number.
How can I sum all the days in the week?
I am thinking a query, something like
I did this but if there was a null in a cell it ignored the whole week.
I am not a pro but I do understand Access.
Re: Sum Across Columns
The nz() function returns the second parameter if the first parameter
evaluates to null.
Set the default value for the day fields to 0 and Nulls Allowed: False