Hi all,
I have an issue which I could do with some help on.
I have a data set (simplified below) that i have loaded into my application:
| ID |
Area |
Manager |
Status |
| 1 |
Northwest |
Jenny |
Active |
| 2 |
Northeast |
Steve |
Closed |
| 3 |
Southwest |
Mike |
Active |
| 4 |
Southeast |
Carol |
Closed |
I want to create a set of text boxes for a report that pull this data out individually i.e. a text box that will display the Area for the ID 1 and another when the ID is 2, so in effect using a lookup type function.
i thought of using an if statement... if(ID=1, Area, ' ') however this only works for me if just the one data line is filtered in the application.
Can anyone help me with this?
Thanks
Chris
