Challenge with an Outer Join query

[Rob.Mills]

I have created a query using two recordsources with an outer join on them. I'm pulling two fields from each source and then I've created another field for each source that performs a calculation on the other two columns. Everything works good except when there aren't matching records. The source that doesn't provide all it's records has a #ERROR message in the calculated field. Anyone know how to change that so it's blank?

 

[samcoinc]

you need to check the data to see if it is there.

like

field1:iif([data1] is null,0,[data1])*iif([data2] is null,0,[data2])

I am sure there are millions of ways to do it but I seem to do it this way.

sam