Text box value based on other text box.

[straybullet]

The report is showing different phases of construction and weeks at each stage. However, the way the information being imported is set up, the current stage comes up as a blank (zero).
Ex: Permits is the first stage. Therefore, Total Weeks in Production (fieldrod) equals the time in Permits. However, in subsequent stages, I would like to show the actual time in Permits.
Thought this would work:

=Iif([foundation]<1,[prod],[permits])

The idea being that if Stage2 (field:foundation) was blank or less than 1, the value of fieldrod would show - but if the job had advanced past the permits stage, the actual weeks in permits would show.
Any suggestions on editing this to work?

Let them hate - so long as they fear... Lucius Accius

 

[dhookom]

Blank" could have many meanings of which I wouldn't think Zero would be one. Is Foundation a text field or numeric? What are the possible values you are storing in the field?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[straybullet]

By blank, I simply mean that the number stored in that field (representing the # of weeks in a constructin stage) does not show in the report when the value is zero. The numbers in both Permits and Foundations range from 0 to 87 (this week) may go higher at any time.

Let them hate - so long as they fear... Lucius Accius

 

[dhookom]

Please type a few records into a reply (maybe in code TGMLs) with the significant fields and what value you would like your expression to return.

Foundation   Prod   Permits  MyExpression
3             1      2         2
5             4      6         6
0             2      4         2
              3      1         3

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[straybullet]

TY for trying to help me with this - Ive given up on calculating this and am simply "stacking" textboxes... The one with information will therefore show. Seems to work so far.

Let them hate - so long as they fear... Lucius Accius