Calculation between two query fields problem

[djokatore]

Hello everyone, I have problem with my query calculation.
Problem is when I want to sum columns from query 1 and column from query 2 and to display results in query 3 they give me results only for fields which is filled.


If I want to sum field from query 1 with field from query 2(not exist, no value) I do not get any result in query 3.
I want that every non-value fields in query 1/2 that are not inserted behave as 0 until their value is entered in the linked table.
Thanks

[JamesDeckert]

try nz([field],0) to replace null values with 0
if that doesn't work then
iif(isnull[field],0,[field])

[June7]

Review http://allenbrowne.com/QueryPerfIssue.html

James, missing () for the IsNull() function.

[JamesDeckert]

thanks june
iif(isnull([field]),0,[field])

[djokatore]

it is not work,in which query of those three i must insert this function?
I want to show me all the factors of the operation although they are not collected
for example,
1 + 1 = 2
2 + non existing field = 2
no existing field + 3 = 3
in my case only
1 + 1 = 2
wherever there is no value for the field there in the final query not show any result or withdraws ID field for one that has a value in one of the query. only withdrawn ID for one that has a value in both query.

[JamesDeckert]

You might not be joining the queries correctly.

[June7]

If you want to provide db for analysis, follow instructions at bottom of my post.