var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: adding functions from VBA to reports
I have a report that is based on a cross tab qry. If one of the columns has no data the rpt shows #Error.
I would like to create a function that uses "Select Sum(Ray) from ExpTypes" to run off ado, if this value returns #Error (from error handling ) return 0
SELECT nz(SUM(Ray), 0)
nz() is a function that evaluates for null. It is of the following syntax:
Therefore SELECT nz(SUM(ray), 0) is stating "Select the sum of the field called ray, if that value is null, return 0"
It may actually be better to write this as:
SELECT SUM(nz(ray, 0))