Null Value relationship

[chrisms]

I have 2 queries that are identical, except one returns the value where Affected = Y and the other where Affected = N.

I then tie these two together in another query by relating them using a Region field.

However when I run the tie in query I get a problem when the affected = N query returns no records, as can happen. This means that the relationship does not hold and therefore the tie in query fails.

How can i fix this?

The 2 identical queries perform calculations and I need them to be calculated for both Affected = N and Affect = Y, but I am pulling them together so I can display all of the results in a form.

Is this a very roundabotu way of solving this problem, is there an easier way of doing it, or can I solve it using the NZ function for the field I am filtering in the two identical queries.

Thanks

Chris

 

[chrisms]

Thanks for that, changed the join and fixed it