IIf

T

terryh70

I use the following code in an unbound text box on a report to extract all
unit records from a query and then place each subsequent entry on the next
line, and shrink and grow if the entry is empty, which works.

=[SUBJECTUNITADDRESS1] & ((Chr(13) & Chr(10))+([SUBJECTUNITADDRESS2])) &
((Chr(13) & Chr(10))+([SUBJECTUNITADDRESS3])) & ((Chr(13) &
Chr(10))+([SUBJECTUNITADDRESS4])) & ((Chr(13) &
Chr(10))+([SUBJECTUNITADDRESS5]))

Another unbound toxbox on the same report with the following code, lists
subjectrank, subjectname, and subjectfirstnames and has the same function as
the other text box. Both work together fine.

=[SUBJECTRANK1] & (" "+[SUBJECTNAME1]) & (", "+[SUBJECTFIRSTNAME1]) &
(Chr(13) & Chr(10))+([SUBJECTRANK2] & (" "+[SUBJECTNAME2]) & (",
"+[SUBJECTFIRSTNAME2])) & (Chr(13) & Chr(10))+([SUBJECTRANK3] & ("
"+[SUBJECTNAME3]) & (", "+[SUBJECTFIRSTNAME3])) & (Chr(13) &
Chr(10))+([SUBJECTRANK4] & (" "+[SUBJECTNAME4]) & (",
"+[SUBJECTFIRSTNAME4])) & (Chr(13) & Chr(10))+([SUBJECTRANK5] & ("
"+[SUBJECTNAME5]) & (", "+[SUBJECTFIRSTNAME5]))

Q: What I would like to do is show only those records from the
subjectunitaddress if they are like "1-26" in the first text box and only
show the corresponding subjectrank, subjectname, and subjectfirstname if the
subjectunit addess is like "1-26"
 
Top