I am creating a report from a query utilizing many LEFT JOINs of multiple queries onto a single query. The problem is that the key value that i am merging on may not have identical values on all of the queries.
FROM (QRY1 LEFT JOIN QRY2 ON QRY1.x = QRY2.x) LEFT JOIN QRY3 ON QRY1.x = QRY3.x
but some values of x in QRY1 are not included in QRY2 or QRY3.
When I join the 3 queries, it will yield "#Error" for QRY2.y or QRY3.y and then show up as "#Error" in the report.
Is there any way to stop "#Error" from printing on the report, or have it show up as Null?