var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Calculating with null values
I have 2 separate queries, one produces a total and one doesn't at the moment as the criteria are not met.
I want to add the total field from both these queries together but becuase one is null value, the sum total is also null.
In access I would have used nz([Qry_1].[Total])+nz([Qry_2].[Total]) to get over this but SQL/adp doesnt seem to understand this.
Can you help?
This worked perfectly - thanks so much