Hello perplexed71,

What are you currently showing for Null values?


Pete

Null values won't print so only zero will have to be removed e.g. in the query using:
FieldX:IIF([field]=0,Null,[field])

This will require a chenge of the fieldnames on the report. Another option is to use conditional formatting and select for the [field] the fontcolor white when equal zero :-)

Nic;o)

Well, if there are Null values - The spaces and places are still being held open and it shows gaps in the report.

Then you need to specify a condition to skip the rows with null or zero's only.
For this a calculation like:
select NZ(field1)+NZ(field2)+NZ(field3) as TestZero from tblX WHERE NZ(field1)+NZ(field2)+NZ(field3) > 0;

can be used.

Nic;o)

you could add this as criteria to the query.

WHERE Not IsNUll([FieldOne]) AND ([FieldOne]) <> 0

Steve

Okay - it may be easier if I just put some code in the field of my report to hide it when its value is 0.

The problem is, I don't know where I would enter code like this on the report.  If I put it in the reports properties, it says that I have entered an expression that has no value.

It should be something like

If Me.LPAuditResultDetail1 = "0" Then
Me.LPAuditResultDetail1.Visible = True

Else
Me.LPAuditResultDetail1.visible = False

End If

Thats my answer!

BTW - Is there a line I can put in that instead of setting the visible property to false that I can just tell it to not include the field at all?  (To avoid unsightly gaps in the report.)

No, when designed you only have this possibility.
One option is however to make the control as small as possible and set the CanGrow property to "Yes"
Thus when all fields on a detail line are treated this way an empty line almost as "nothing"

Nic;o)

:-)  Thanks!