OMIT CERTAIN VALUES ON REPORT

[xcavern]

Is there a way to have a textbox, if the value is "0" be blank?

Thanks for the help!

 

[Remou]

As in (?):
[tt]=IIf(nz([SomeField])=0,"",[SomeField])[/tt]

 

[xcavern]

The info is from table "Sheet 1" column "1", how would that work?

 

[xcavern]

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

When I put in =IIf(nz([1])=0,"",[1]) , it comes up an error. Is this the correct way to do this ?

 

[Remou]

Is this Excel? This is the Access Reports Forum. If it is Access, What are the field names in table "Sheet 1"?

 

[xcavern]

the actual columns names (field names) are, 1 , 2, 3, 4, ..ect

 

[Remou]

Rename the control on the report to, for example, 1x. Anything other than the same name as the fields. As a ps, I think you may run into problems with these field names.

 

[xcavern]

Thanks this is perfect. I'm hoping I wont run into trouble with numbers as fieldnames, and will definitally use something else next time.

Thanks for the help