[AccessD] help with a query...

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 





More information about the AccessD mailing list