Hiding lines in detail

  • Thread starter Thread starter Ana
  • Start date Start date
A

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
 
Ana said:
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
Click to expand...

Is there a reason the report's query could not just include criteria that
would filter those rows out?
 
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
 
Back
Top