swilliams2785
Registered User.
- Local time
- Today, 10:34
- Joined
- Jun 24, 2010
- Messages
- 19
I have a report with two groups identified, STDNO followed by GP. The value of GP in the table is either 1, 2, 3, or 4 and follows this sequence all the way through. I have a text box in the GP footer that captures the value of a field named NS in the detail section of the report based on the value of GP. The text box Control Source contains =IIf([GP]=1,[NS]). After I confirmed that the formula was working I copied it to a new text box and changed the formula to test for a value of 2 for GP. The formulas in the first box works perfectly but the second one always returns a blank. I have placed the GP field in the footer to test the value and it displays as expected. I even tried changing the test value in the first box to 2 and then it returns blanks. The same thing happens for GP values of 3 and 4. Any ideas?