I am trying to get the info to show if it does not equal the information in a previous row where the Sub_No = 0
The original code is:
Code:
IIf(([Sub_No]=0),[Unit],"") & Chr(13) & Chr(10) & IIf(([Sub_No]=0),[Section],"")
This is what I have come up with, but I think it is circular and will always find that where Sub_No <> 0, it will be = to the row where Sub_No = 0.
Code:
IIf(([Sub_No]=0),[Unit], (IIf(([Unit]=[Unit]),"",[Unit]))) & Chr(13) & Chr(10) & IIf(([Sub_No]=0),([Section]),(IIf(([Section]=[Section]),"",[Section])))
My intent is if the Sub_No <> 0 it won'tdisplay [Unit] unless it is different from where Sub_No = 0
Data:
CR_No=1
Sub_No = 0....Unit =John
Sub_No = 1....Unit =John
Sub_No = 2....Unit =Jane
Sub_No = 3....Unit =John
Sub_No = 4....Unit =Jay
Output:
1.0....John
.1....
.2....Jane
.3....
.4....Jay
Don't worry about the CR_No, I have that figured out from Snafu assistance already.
Thanks