Kostas Konstantinidis
kost36 at otenet.gr
Mon May 4 06:57:37 CDT 2009
dear group,
I am using the follown query before a report...
Director: ([Names.name]+Chr(13)+Chr(10)) & ([addr1_dir1]+Chr(13)+Chr(10)) &
([addr2_dir1]+Chr(13)+Chr(10)) & ([TK_dir1] & " " &
[T_perioxi.perioxi]+Chr(13)+Chr(10)) & ([T_town.poli]+Chr(13)+Chr(10)) &
([T_kratos.kratos]+Chr(13)+Chr(10)) &
([Names_1.name]+Chr(13)+Chr(10)) & ([addr1_dir2]+Chr(13)+Chr(10)) &
([addr2_dir2]+Chr(13)+Chr(10)) & ([TK_dir2] & " " &
[T_perioxi_1.perioxi]+Chr(13)+Chr(10)) & ([T_town_1.poli]+Chr(13)+Chr(10)) &
([T_kratos_1.kratos]+Chr(13)+Chr(10)) &
([Names_2.name]+Chr(13)+Chr(10)) & ([addr1_dir3]+Chr(13)+Chr(10)) &
([addr2_dir3]+Chr(13)+Chr(10)) & ([TK_dir3] & " " &
[T_perioxi_2.perioxi]+Chr(13)+Chr(10)) &
([T_town_2.poli]+Chr(13)+Chr(10))+[T_kratos_2.kratos]
Please, I need some help with two questions
1. If the sequences Names_1.name and Names_2.name are blank (have no data)
then to the end of the field
Director returns a space character and an enter character too
2. Is there any way to print in bold only the Names.Name, Names_1.name and
Names_2.name
many thank's
/kostas