Dear All,
Again, thanks for your earlier help.
I have a report which has students progress. The progress is measured by the Section they are on and the Total Sections for the Course.
The two fields I have is [Section] and [Sections] on the report which I am trying to make show, I conquered the first part.
I have laid out my report as a progress report and I have textboxes for each Section, like this:
Student |
Course |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
John Jones |
Blah Blah Course |
X |
X |
X |
|
|
|
|
|
Hillary Main |
Blah Blah Blah Course |
X |
X |
X |
X |
X |
X |
|
|
I figured out how to fill out the individual cells with "X" if they are done with that section.
Here is my Control Source for one of these textboxes (so you get an idea):
Code:
=IIf([Sec]>=13,"X","")
This code is in the 13th textbox Control Source.
Now here is my problem, which I am sure can easily be figured out, how do I put a "E" in
the textbox if it is at the end of the Sections (i.e. the last section of the course).
I tried finding out how to nest the IIF statement, but got nowhere. Then I tried "OR" in it but that
doesn't work.
Basically what I want to do is as follows:
Code:
=IIf([Sec]>=13,"X","") AND IIf([Sec]=[Secs],"E","")
But that doesn't work. By the way "Sec" is "Section" and "Secs" is Total Sections in the Course.
Any pointers?
Thanks!
Phil