My report is not showing all fields required from the source query.

[atrium]

when I view the source query

SELECT Clients.ClientId, Clients.ClientGroup, Clients.ClientFileNumber, RTrim([Clients]![FirstName] & " " & [Clients]![LastName]) AS ClientName, Clients.LastName, DdSchedules.Status, Matters.Description, Matters.DebtPrinciple, IIf([JudgementAmount]>0,[JudgementAmount],[DebtPrinciple]) AS MainDebt, IIf([JudgementAmount]>0,"J/Debt","P/Debt") AS PrincOrJudgFld, Matters.JudgementAmount, SumOfInterestQry.TotInterest, Matters.InterestAmount, SumOfPaymentsMadeQry.TotPayments, IIf(([MainDebt]+Nz([InterestAmount]))-Nz([TotPayments])<>0,([MainDebt]+Nz([InterestAmount]))-Nz([TotPayments]),0) AS Balance, Matters.ClientRefNo, Matters.OperStatus, Matters.MatterId, Matters.MatterShortNo, Matters.MatterLongNo, Matters.ClientId, Matters.MatterTitle, Matters.Description, Matters.CollLongNo, Matters.CollShortNo, RTrim([Debtors]![FirstName] & " " & [Debtors]![LastName]) AS DebtorsName
FROM ((((Clients LEFT JOIN Matters ON Clients.ClientId = Matters.ClientId) LEFT JOIN Debtors ON Matters.MatterId = Debtors.MatterId) LEFT JOIN SumOfInterestQry ON Matters.MatterId = SumOfInterestQry.MatterId) LEFT JOIN SumOfPaymentsMadeQry ON Matters.MatterId = SumOfPaymentsMadeQry.MatterId) LEFT JOIN DdSchedules ON Matters.MatterId = DdSchedules.MatterId
WHERE (((Clients.ClientGroup)=[Forms]![SelectClientGroupFrm]![ClientGroupFld]))
ORDER BY Clients.ClientId, Matters.ClientId;



Then output of the above is

The columns with yellow highlight

1. The PrincOrJudg column contents Appear intermittently - there doesn't seem to be any logic when they appear, but each time I run the report the same ones are not there
2. The same with the Interest column
3. The balance column appears as expected

The report is as follows - ANY HELP would be very appreciated

 

[arnelgp]

did you set the Hide Duplicate (Design View->Property->Format) on textbox PrincOrJudgFld on your report to Yes. It should be set to No.

 

[atrium]

ARNELP you are a marvel. That was the problem Thanks very much