R
Rick Stahl
In a query I am trying to sum currency fields from subqueries. Some of
these fields are blank because no value should be there. Where there is
values in all fields of a given record, summation works fine. However
wherever there is a blank field, no sum is returned. Do I have to make all
the blank fields zero or is there a way I can sum the fields "as is" by
somehow stating somewhere "if null, then equals zero" ? Thank you.
these fields are blank because no value should be there. Where there is
values in all fields of a given record, summation works fine. However
wherever there is a blank field, no sum is returned. Do I have to make all
the blank fields zero or is there a way I can sum the fields "as is" by
somehow stating somewhere "if null, then equals zero" ? Thank you.