This query just adds the values of two fields from 2 different tables.
I have this formula in my query. I want to modify it to accept null values
FIELD6: First([EXTRACT_O32-05]![F6]+[EXTRACT_O35-05]![F6])
I tried:
FIELD6: First(([EXTRACT_O32-05]!(Nz([F6])+[EXTRACT_O35-05]!(Nz([F6]))
Any thoughts?
Figured it out, just thought I would post it anyways...
Solution:
FIELD6: First(Nz([EXTRACT_O32-05]![F6])+Nz([EXTRACT_O35-05]![F6]))
Cheers
I have this formula in my query. I want to modify it to accept null values
FIELD6: First([EXTRACT_O32-05]![F6]+[EXTRACT_O35-05]![F6])
I tried:
FIELD6: First(([EXTRACT_O32-05]!(Nz([F6])+[EXTRACT_O35-05]!(Nz([F6]))
Any thoughts?
Figured it out, just thought I would post it anyways...
Solution:
FIELD6: First(Nz([EXTRACT_O32-05]![F6])+Nz([EXTRACT_O35-05]![F6]))
Cheers