Multiple contol sources for one text box?

[Joe]

Hi,

I am creating a report and I want to have in one text box
the values from two diffierent tables. I go into
Expression Builder and can get any information from the
one table that the report is "controled" from. But when I
additionally try to "&" another field from another table,
I get an error message.

Is it possible to do such? It seems as if Expression
Builder lets you do it, but then returns the error message.

Thanks!

Joe

 

[SA]

Joe:

No there's no way to do that using expression builder. If you've added both
tables to your report's underlying query, then you can create an alias field
in the query that combines the values as in the following for two text
values:

MultiValue: [tblOneName].[FieldName] & " " & [tblTwoName].[FieldName]