Line break

[Guest]

I have the following in the controll source of an unbound text box on a form,
which enters Rank then two spaces, then last name seperated by a comma and a
space then the next 4 entries are the same but on different lines. The
unbound box and the form detail section are set to can grow and can shrink.

The problem is that if the fields are empty then the comma still shows up on
its own line and the report does not shrink.

Also how can I get each new entry be seperated by a line that is visible on
the report. If I draw the lines on the report, then they show up but the
report no longer grows and shrinks and always shows the lines even if there
is not data in it.


=[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]

 

[John Spencer]

=[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]))

Using the combination of + and & to concatenate the values and forcing
operational order using parentheses, the above may give you what you want.

I'm not sure about your question on separation lines.

 

[Guest]

Thanks that worked perfectly. The only thing is I am having trouble
duplicating the same feature for other similiar fields. Maybe you could help
me with them also.

Each field should be on different line:

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


This is similiar to the first one you helped with, rank1, name1, and first
name1 should be on one line, then unitaddress1 should be line 2, then rank2,
name2, and firstname2, on line 3 and so on.

=[SUBJECTRANK1] & " " & [SUBJECTNAME1] & " " & [SUBJECTFIRSTNAME1] & " " &
[SUBJECTUNITADDRESS1] & " " & [SUBJECTRANK2] & " " & [SUBJECTNAME2] & " " &
[SUBJECTFIRSTNAME2] & " " & [SUBJECTUNITADDRESS2] & " " & [SUBJECTRANK3] &
" " & [SUBJECTNAME3] & " " & [SUBJECTFIRSTNAME3] & " " &
[SUBJECTUNITADDRESS3] & " " & [SUBJECTRANK4] & " " & [SUBJECTNAME4] & " " &
[SUBJECTFIRSTNAME4] & " " & [SUBJECTUNITADDRESS5] & " " & [SUBJECTRANK6] &
" " & [SUBJECTNAME6] & " " & [SUBJECTFIRSTNAME6] & " " &
[SUBJECTUNITADDRESS6] & " " & [SUBJECTRANK7] & " " & [SUBJECTNAME7] & " " &
[SUBJECTFIRSTNAME7] & " " & [SUBJECTUNITADDRESS7] & " " & [SUBJECTRANK8] &
" " & [SUBJECTNAME8] & " " & [SUBJECTFIRSTNAME8] & " " &
[SUBJECTUNITADDRESS8] & " " & [SUBJECTRANK9] & " " & [SUBJECTNAME9] & " " &
[SUBJECTFIRSTNAME9] & " " & [SUBJECTUNITADDRESS9] & " " & [SUBJECTRANK10]
& " " & [SUBJECTNAME10] & " " & [SUBJECTFIRSTNAME10] & " " &
[SUBJECTUNITADDRESS10] & " " & [SUBJECTRANK11] & " " & [SUBJECTNAME11] & " "
& [SUBJECTFIRSTNAME11] & " " & [SUBJECTUNITADDRESS11]

Thanks so much in advance, this stuff was killing me.

=[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]))

Using the combination of + and & to concatenate the values and forcing
operational order using parentheses, the above may give you what you want.

I'm not sure about your question on separation lines.

I have the following in the controll source of an unbound text box on a
form,
which enters Rank then two spaces, then last name seperated by a comma and
a
space then the next 4 entries are the same but on different lines. The
unbound box and the form detail section are set to can grow and can
shrink.

The problem is that if the fields are empty then the comma still shows up
on
its own line and the report does not shrink.

Also how can I get each new entry be seperated by a line that is visible
on
the report. If I draw the lines on the report, then they show up but the
report no longer grows and shrinks and always shows the lines even if
there
is not data in it.


=[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]

 

[BruceM]

As I understand using the + sign in concatenation, if one of the values is
null then that part of the string is null. For example, if [SUBJECTNAME1]
is null, then this part of the expression:
(" " + [SUBJECTNAME1])
is also null. Therefore, the space (or the comma) is swallowed up by the
null value in the field, and does not appear. If Rank1,Name1, and
FirstName1 fields are null, then the concatenation is Null & Null & Null,
which amounts to Null.
As an aside, I wonder about your database structure. Whatever your main
table is, all of the Subject information should probably be in a separate
table that is related one-to-many to the main table. A continuous subform
based on the Subject table would solve your problems, and eliminate the need
for an elaborate concatenation expression. Just guessing, but it seems
likely enough.

Thanks that worked perfectly. The only thing is I am having trouble
duplicating the same feature for other similiar fields. Maybe you could
help
me with them also.

Each field should be on different line:

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


This is similiar to the first one you helped with, rank1, name1, and first
name1 should be on one line, then unitaddress1 should be line 2, then
rank2,
name2, and firstname2, on line 3 and so on.

=[SUBJECTRANK1] & " " & [SUBJECTNAME1] & " " & [SUBJECTFIRSTNAME1] & " "
&
[SUBJECTUNITADDRESS1] & " " & [SUBJECTRANK2] & " " & [SUBJECTNAME2] & " "
&
[SUBJECTFIRSTNAME2] & " " & [SUBJECTUNITADDRESS2] & " " &
[SUBJECTRANK3] &
" " & [SUBJECTNAME3] & " " & [SUBJECTFIRSTNAME3] & " " &
[SUBJECTUNITADDRESS3] & " " & [SUBJECTRANK4] & " " & [SUBJECTNAME4] & " "
&
[SUBJECTFIRSTNAME4] & " " & [SUBJECTUNITADDRESS5] & " " &
[SUBJECTRANK6] &
" " & [SUBJECTNAME6] & " " & [SUBJECTFIRSTNAME6] & " " &
[SUBJECTUNITADDRESS6] & " " & [SUBJECTRANK7] & " " & [SUBJECTNAME7] & " "
&
[SUBJECTFIRSTNAME7] & " " & [SUBJECTUNITADDRESS7] & " " &
[SUBJECTRANK8] &
" " & [SUBJECTNAME8] & " " & [SUBJECTFIRSTNAME8] & " " &
[SUBJECTUNITADDRESS8] & " " & [SUBJECTRANK9] & " " & [SUBJECTNAME9] & " "
&
[SUBJECTFIRSTNAME9] & " " & [SUBJECTUNITADDRESS9] & " " &
[SUBJECTRANK10]
& " " & [SUBJECTNAME10] & " " & [SUBJECTFIRSTNAME10] & " " &
[SUBJECTUNITADDRESS10] & " " & [SUBJECTRANK11] & " " & [SUBJECTNAME11] &
" "
& [SUBJECTFIRSTNAME11] & " " & [SUBJECTUNITADDRESS11]

Thanks so much in advance, this stuff was killing me.

=[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]))

Using the combination of + and & to concatenate the values and forcing
operational order using parentheses, the above may give you what you
want.

I'm not sure about your question on separation lines.

I have the following in the controll source of an unbound text box on a
form,
which enters Rank then two spaces, then last name seperated by a comma
and
a
space then the next 4 entries are the same but on different lines. The
unbound box and the form detail section are set to can grow and can
shrink.

The problem is that if the fields are empty then the comma still shows
up
on
its own line and the report does not shrink.

Also how can I get each new entry be seperated by a line that is
visible
on
the report. If I draw the lines on the report, then they show up but
the
report no longer grows and shrinks and always shows the lines even if
there
is not data in it.


=[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]

 

[Guest]

Yes, you are more than right. If have learned access on my own over the last
few years, but have never gone into this much detail in a databse. I have
several different things that should probably be in their own table and have
never messed with relatinships before. Programing is not my main job, created
a databse to make my job easier, which it has, now my boss has seen it and I
have had to incorporate a lot more data and a lot more functions. The problem
now is that it would probable take me forever to redesign the data structure
with all of the data already entered.

Thanks for your help. The information you provided was very useful.

As I understand using the + sign in concatenation, if one of the values is
null then that part of the string is null. For example, if [SUBJECTNAME1]
is null, then this part of the expression:
(" " + [SUBJECTNAME1])
is also null. Therefore, the space (or the comma) is swallowed up by the
null value in the field, and does not appear. If Rank1,Name1, and
FirstName1 fields are null, then the concatenation is Null & Null & Null,
which amounts to Null.
As an aside, I wonder about your database structure. Whatever your main
table is, all of the Subject information should probably be in a separate
table that is related one-to-many to the main table. A continuous subform
based on the Subject table would solve your problems, and eliminate the need
for an elaborate concatenation expression. Just guessing, but it seems
likely enough.

Thanks that worked perfectly. The only thing is I am having trouble
duplicating the same feature for other similiar fields. Maybe you could
help
me with them also.

Each field should be on different line:

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


This is similiar to the first one you helped with, rank1, name1, and first
name1 should be on one line, then unitaddress1 should be line 2, then
rank2,
name2, and firstname2, on line 3 and so on.

=[SUBJECTRANK1] & " " & [SUBJECTNAME1] & " " & [SUBJECTFIRSTNAME1] & " "
&
[SUBJECTUNITADDRESS1] & " " & [SUBJECTRANK2] & " " & [SUBJECTNAME2] & " "
&
[SUBJECTFIRSTNAME2] & " " & [SUBJECTUNITADDRESS2] & " " &
[SUBJECTRANK3] &
" " & [SUBJECTNAME3] & " " & [SUBJECTFIRSTNAME3] & " " &
[SUBJECTUNITADDRESS3] & " " & [SUBJECTRANK4] & " " & [SUBJECTNAME4] & " "
&
[SUBJECTFIRSTNAME4] & " " & [SUBJECTUNITADDRESS5] & " " &
[SUBJECTRANK6] &
" " & [SUBJECTNAME6] & " " & [SUBJECTFIRSTNAME6] & " " &
[SUBJECTUNITADDRESS6] & " " & [SUBJECTRANK7] & " " & [SUBJECTNAME7] & " "
&
[SUBJECTFIRSTNAME7] & " " & [SUBJECTUNITADDRESS7] & " " &
[SUBJECTRANK8] &
" " & [SUBJECTNAME8] & " " & [SUBJECTFIRSTNAME8] & " " &
[SUBJECTUNITADDRESS8] & " " & [SUBJECTRANK9] & " " & [SUBJECTNAME9] & " "
&
[SUBJECTFIRSTNAME9] & " " & [SUBJECTUNITADDRESS9] & " " &
[SUBJECTRANK10]
& " " & [SUBJECTNAME10] & " " & [SUBJECTFIRSTNAME10] & " " &
[SUBJECTUNITADDRESS10] & " " & [SUBJECTRANK11] & " " & [SUBJECTNAME11] &
" "
& [SUBJECTFIRSTNAME11] & " " & [SUBJECTUNITADDRESS11]

Thanks so much in advance, this stuff was killing me.

=[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]))

Using the combination of + and & to concatenate the values and forcing
operational order using parentheses, the above may give you what you
want.

I'm not sure about your question on separation lines.

I have the following in the controll source of an unbound text box on a
form,
which enters Rank then two spaces, then last name seperated by a comma
and
a
space then the next 4 entries are the same but on different lines. The
unbound box and the form detail section are set to can grow and can
shrink.

The problem is that if the fields are empty then the comma still shows
up
on
its own line and the report does not shrink.

Also how can I get each new entry be seperated by a line that is
visible
on
the report. If I draw the lines on the report, then they show up but
the
report no longer grows and shrinks and always shows the lines even if
there
is not data in it.


=[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]

 

[BruceM]

If you ever want to break apart the data into a properly normalized design,
post the details of what you have and what you are trying to do. It may not
be as difficult as you imagine, and would give you a lot more flexibility
(and save a lot of time) in the future.

Yes, you are more than right. If have learned access on my own over the
last
few years, but have never gone into this much detail in a databse. I have
several different things that should probably be in their own table and
have
never messed with relatinships before. Programing is not my main job,
created
a databse to make my job easier, which it has, now my boss has seen it and
I
have had to incorporate a lot more data and a lot more functions. The
problem
now is that it would probable take me forever to redesign the data
structure
with all of the data already entered.

Thanks for your help. The information you provided was very useful.

As I understand using the + sign in concatenation, if one of the values
is
null then that part of the string is null. For example, if
[SUBJECTNAME1]
is null, then this part of the expression:
(" " + [SUBJECTNAME1])
is also null. Therefore, the space (or the comma) is swallowed up by the
null value in the field, and does not appear. If Rank1,Name1, and
FirstName1 fields are null, then the concatenation is Null & Null & Null,
which amounts to Null.
As an aside, I wonder about your database structure. Whatever your main
table is, all of the Subject information should probably be in a separate
table that is related one-to-many to the main table. A continuous
subform
based on the Subject table would solve your problems, and eliminate the
need
for an elaborate concatenation expression. Just guessing, but it seems
likely enough.

Thanks that worked perfectly. The only thing is I am having trouble
duplicating the same feature for other similiar fields. Maybe you could
help
me with them also.

Each field should be on different line:

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


This is similiar to the first one you helped with, rank1, name1, and
first
name1 should be on one line, then unitaddress1 should be line 2, then
rank2,
name2, and firstname2, on line 3 and so on.

=[SUBJECTRANK1] & " " & [SUBJECTNAME1] & " " & [SUBJECTFIRSTNAME1] & "
"
&
[SUBJECTUNITADDRESS1] & " " & [SUBJECTRANK2] & " " & [SUBJECTNAME2] &
" "
&
[SUBJECTFIRSTNAME2] & " " & [SUBJECTUNITADDRESS2] & " " &
[SUBJECTRANK3] &
" " & [SUBJECTNAME3] & " " & [SUBJECTFIRSTNAME3] & " " &
[SUBJECTUNITADDRESS3] & " " & [SUBJECTRANK4] & " " & [SUBJECTNAME4] &
" "
&
[SUBJECTFIRSTNAME4] & " " & [SUBJECTUNITADDRESS5] & " " &
[SUBJECTRANK6] &
" " & [SUBJECTNAME6] & " " & [SUBJECTFIRSTNAME6] & " " &
[SUBJECTUNITADDRESS6] & " " & [SUBJECTRANK7] & " " & [SUBJECTNAME7] &
" "
&
[SUBJECTFIRSTNAME7] & " " & [SUBJECTUNITADDRESS7] & " " &
[SUBJECTRANK8] &
" " & [SUBJECTNAME8] & " " & [SUBJECTFIRSTNAME8] & " " &
[SUBJECTUNITADDRESS8] & " " & [SUBJECTRANK9] & " " & [SUBJECTNAME9] &
" "
&
[SUBJECTFIRSTNAME9] & " " & [SUBJECTUNITADDRESS9] & " " &
[SUBJECTRANK10]
& " " & [SUBJECTNAME10] & " " & [SUBJECTFIRSTNAME10] & " " &
[SUBJECTUNITADDRESS10] & " " & [SUBJECTRANK11] & " " & [SUBJECTNAME11]
&
" "
& [SUBJECTFIRSTNAME11] & " " & [SUBJECTUNITADDRESS11]

Thanks so much in advance, this stuff was killing me.




:

=[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]))

Using the combination of + and & to concatenate the values and forcing
operational order using parentheses, the above may give you what you
want.

I'm not sure about your question on separation lines.

I have the following in the controll source of an unbound text box on
a
form,
which enters Rank then two spaces, then last name seperated by a
comma
and
a
space then the next 4 entries are the same but on different lines.
The
unbound box and the form detail section are set to can grow and can
shrink.

The problem is that if the fields are empty then the comma still
shows
up
on
its own line and the report does not shrink.

Also how can I get each new entry be seperated by a line that is
visible
on
the report. If I draw the lines on the report, then they show up but
the
report no longer grows and shrinks and always shows the lines even
if
there
is not data in it.


=[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]