I've created a simple tabular report in Access 2003 that lists values for products in 2 columns. The first column has positive values in it and the second has negative values in it. However there are a lot of zero values that just clutter the report and I want to suppress all of them so that they do not show on the report. I've tried modifying the qry that the report is based on to show a null value but then I cannot get a total at the bottom of the report. I've tried changing the hide duplicates property of the fields on the report but this still shows the first zero. Any ideas?

<> 0 in the criteria of your query

Thanks Rich,

In this instance it doesn't work as I am derriving the 0 value based on the data contained within another field with the formula iif([field1]) = "A", [Field1], 0). My first thoughts were to change the 0 to "" or Null. This works but when I try to total the report it gives me an error. If I put the <>0 in the query criteria for both columns I don't return any records.

Did you ever get this sorted as I am having the same problem

Found the solution on another site

Set the Format Property of the control to:

#;-#;""