Two different sources in the same text box 1

[elefantmannen]

I read in some post about adding two differet sources in the same text box. (Like value1 + " " + value2) but I cant find it when searching the forums. Someone who can direct me to the post or just put the answer here??

 

[CosmoKramer]

It would be something like this:

=[value1] & " " & [value2]

 

[elefantmannen]

yes it works, but there is still a problem here... I have a query where information comes from two different tables and they have the same name. (table1 has a name, and table2 has a name) so I would like to write =[table1.name] & " " & [table2.name], but it doesnt work...

 

[TLady]

Try this way
=table1.[name] & " " & table2.[name]
TIA

 

[elefantmannen]

no, it doesnt work.
I write it in the textbox, save it and run the report. When I open the design again access has changed it into
=table1.name & " " & table2.name

 

[danvlas]

Of course...using reserved words as field names is always a bad idea.
This will work:

table1![name] & " " & table2![name]

Good luck




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html