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