Help with if - then statement

  • Thread starter Thread starter Eaton1379
  • Start date Start date
E

Eaton1379

I am really new at this and hope you can help.

The database goes from 1995 thru 2034 with 7 specific activity field
for each year as well identification data. I have been told that
need to normalize the database(eventually I will figure that one out.)

But for now I have a report with

Year Dep Wd etc Total
1995 100 0 etc 100
I want the year field only to appear when the total is greater than 0

I have tried using
IIF(1995 Total is not null,"Display")

When I run the report I have to tell the parameter value for the year.
How do I write the formula to show the year automatically.

Also since the total field could be less than 0 how do I get the fiel
not to show when the total is 0.

Thanks muc
 
Use conditional formatting. Right-click on the control
for the year. Select conditional formatting. Then
use "condition" rather than field. In the condition field
say [Total]>0
 
Back
Top