SELECT
    [04_Match to Pending Consolidation].*,
    IIf(IsNull([Matched_Closed_Not_Invoiced_Report],0) + IsNull([Matched_Shipped_Not_Invoiced_report],0)+IsNull([Matched_Pending_Consolidation_Report],0),"NONE","EITHER REPORT") AS Validation
FROM
    [04_Match to Pending Consolidation];