>I have a left outer join that leaves me with numbers
>on records where a match is found and nulls on records
>where it doesnt.
>
>I there a setting to make these nulls zeroes so its easier to work with them?
>
>
>TIA
>Chris
You could use old-fashioned UNION syntax to provide exact (blank, zeros or something else) values on right side.
Edward Pikman
Independent Consultant