Hiding lines in detail

[Ana]

Hi,
I'd like to hide a line when a field from a query = a 0 or IS NULL.
Meaning:
Client_name Bill# Total
Joe Brown 123456 $1.500 (this line should appear)
Joe Brown (this line shouldn't appear)

HOWTO do it?
TIA
Ana
Access 2003

 

[Rick Brandt]

Hi,
I'd like to hide a line when a field from a query = a 0 or IS NULL.
Meaning:
Client_name Bill# Total
Joe Brown 123456 $1.500 (this line should appear)
Joe Brown (this line shouldn't appear)

HOWTO do it?
TIA
Ana
Access 2003

Is there a reason the report's query could not just include criteria that
would filter those rows out?

 

[Ofer Cohen]

In the report record source add a criteria to the field

Is Not Null And <> 0

In SQL
Select * From TableName Where FieldName Is Not Null And FieldName <> 0