[AccessD] help with a query...

I think you have a problem with where you are using the plus sign for
concatination verses the Ampersand. You may be aware of that which is
why you are using a combination but I would try to replace all the +
signs with ambersands and see if it clears your problem. I'm not clear
on the exact difference between the two or I would elaborate.

Good luck with it.

GK

On Mon, May 4, 2009 at 6:57 AM, Kostas Konstantinidis <kost36 at otenet.gr> wrote:
> 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
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Gary Kjos
garykjos at gmail.com