adding values between 2 tables (1 Viewer)

!Rdooley

New member
Local time
Today, 12:15
Joined
Oct 17, 2003
Messages
7
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 :D
 

Users who are viewing this thread

Top Bottom