Thanks for the help PHV but it still won't work. I'm using that code in the format field of the report, but the zeros are stilling showing up. I've tried other forumns and ideas, but to no avail. If I tell the computer to display "" if it is a zero then I get an error for my totals. Here is the SQL code for the query. Any more ideas?
SELECT PolicyInfo.ClaimNumber, PolicyInfo.PolicyNumber, PolicyInfo.RegisteNumber, BasicInfo.Filed, IIf([Filed]=Yes,[PolicyNumber],"") AS PolicyFiled, PolicyInfo.IssueDate, IIf([Filed]=Yes,[TotalAmount],"-") AS TotalAmountFiled, PolicyInfo.BeneficiaryL, PolicyInfo.BeneficiaryMI, BasicInfo.DateNotified, BasicInfo.DateofBirth, BasicInfo.DateofDeath, BasicInfo.LastName, BasicInfo.FirstName, BasicInfo.MiddleInitial, PolicyInfo.[DateFormsRcv'd], PolicyInfo.DatePaid, IIf([Filed]=Yes,[PlanCode],"") AS PlanCodeFiled, BasicInfo.Print, ([LastName] & ", " & [FirstName] & " " & [MiddleInitial]) AS Name, BasicInfo.CaseNumber, BasicInfo.InvoiceDate, IIf([Filed]=No,[PolicyNumber],"") AS PolicyNotFiled, IIf([Filed]=No,[PlanCode],"") AS PlanCodeNotFiled, IIf([Filed]=No,[TotalAmount],"-") AS TotalAmountNotFiled, Format([InvoiceDate],"mmmm") AS [Month], BasicInfo.Company, Format([InvoiceDate],"mm") AS InvoiceMonth
FROM BasicInfo INNER JOIN PolicyInfo ON BasicInfo.RegisterNumber = PolicyInfo.RegisteNumber
WHERE (((BasicInfo.Print)=Yes) AND ((BasicInfo.Company)="RFH"));
Thanks
John