I have query with a join that is not displaying 3 lines and I don't know why. I had previously posted something similar to this and tried to use that response to correct this problem but I can't figure out why these lines are not showing in the query. I need all lines from both the table and the query to display in my output even if they only exist on one of the sources. The lines that are not displaying are on the "Aging_Billing_Query" but not on the "Service_Channel" tables. I have other lines that are on the "Aging_Billing_Query" but not on the "Service_Channel" table that are showing up so I am very confused about the disconnect. I am not very knowledgeable in Access so please be gentle on the terms that you use when responding to me... . I did try to make it a left outer join and the output is exactly the same.
SELECT DISTINCT [Aging_ Billers_Query].FB, Service_Channel.Client, Service_Channel.LocationName AS Location, Service_Channel.[W#O##] AS [Work Order #], [Aging_ Billers_Query].[PO #], Service_Channel.Status AS [Web Status], [Aging_ Billers_Query].Biller, Service_Channel.[Inv##] AS [Uploaded Inv #], Service_Channel.[Inv#Amount] AS [Amt Entered], [Aging_ Billers_Query].[Inv #] AS [Aging Inv #], [Aging_ Billers_Query].[Inv Amt], IIf([Inv #]=[Inv##],"Match","Mismatch") AS Mismatch, IIf([Inv#Amount]=[Inv Amt],"Match","Mismatch") AS [Mismatch Var], "Service Channel" AS Portal, IIf([mismatch]="mismatch" And [Aging Inv #] Is Null,"PAID") AS PAID
FROM Service_Channel LEFT JOIN [Aging_ Billers_Query] ON Service_Channel.[W#O##] = [Aging_ Billers_Query].[PO #];