Identifying Records not to show on a report

[RichB]

I have a query with an expression that adds two fields. When I print the report I do not want the records that contain a 0(zero). I have looked at IsNull but it does not work due to the fact that there is still a 0 in the field. Any help on excluding records on a report?

[This message has been edited by RichB (edited 07-12-2001).]

 

[Rich]

Put >0 in the criteria grid howevever if your working with negative values then put <>0
HTH

 

[Talismanic]

I might be misunderstanding your question but you can use the NZ function , I think it stands for Null Zero. It will give you a blank field but still treat it as a 0


Total = (Nz(.FirstField, 0) + Nz(.SecondField, 0)

 

[RichB]

Sorry, my explaination has much to be desired. Let me try this;I have an unlinked calculated field on my report that will turn out a number. I do not want this record to show up if the field contains a zero. No negatives to consider.
I tried the Total = (Nz(.firstfield, 0)+ Nz(.SecondField, 0) and it turned all fields to Null not just the fields with 0. Hope this explains it better.

 

[Rich]

Try in the on Format Event
If Me.YourField =0 Then
Me.YourField.Visible=False
Else
Me.YourField.Visible=True
End If
HTH

 

[RichB]

Thanks, Rich, your last input helped.