Combine fields into a text

[Guest]

I would like to comine several fields of a query into a single field.

My current statement is:

Structure: +[Structure Builder]![Base Layer Amount] & " " & [Structure
Builder]![Base Layer Units] & " " & [Structure Builder]![Base Layer Material]
& "/"


the problem is "Base Layer Material" uses a a bound column which is a
number, I need to have the text from another field in that table. What is the
best way of doing this?

 

[Guest]

Remove the plus sign. Try using Val([Structure Builder]![Base Layer
Material]).

I do not understand your statement "I need to have the text from another
field in that table."

 

[Guest]

I made change as suggested below - no apparent change in output.

The "base layer material " is a lookup field in a table. The table stores
the autonumber "ID" number of that recordset. But I want to see the field
"material" (which is text) not the field "ID" (which is a number).

So the out looks like this currently:

10 lbs/ream 64/

Need it to be:

10 lbs/ream Polyester/

64 being the ID of the Polyester MATERIAL

thanks



--
David McKnight

Remove the plus sign. Try using Val([Structure Builder]![Base Layer
Material]).

I do not understand your statement "I need to have the text from another
field in that table."

I would like to comine several fields of a query into a single field.

My current statement is:

Structure: +[Structure Builder]![Base Layer Amount] & " " & [Structure
Builder]![Base Layer Units] & " " & [Structure Builder]![Base Layer Material]
& "/"


the problem is "Base Layer Material" uses a a bound column which is a
number, I need to have the text from another field in that table. What is the
best way of doing this?

 

[Guest]

Open the query in design view. Click on the icon that has a yellow plus sign
and table. Select "material" table. If you have set a relation between the
tables there will be a line connecting the ID fields of the two tables.
If not then click on the ID field of thematerial table and drag to the other
table matching field.
Use the narrative field from the materials table in your concatenated field.

I made change as suggested below - no apparent change in output.

The "base layer material " is a lookup field in a table. The table stores
the autonumber "ID" number of that recordset. But I want to see the field
"material" (which is text) not the field "ID" (which is a number).

So the out looks like this currently:

10 lbs/ream 64/

Need it to be:

10 lbs/ream Polyester/

64 being the ID of the Polyester MATERIAL

thanks



--
David McKnight

Remove the plus sign. Try using Val([Structure Builder]![Base Layer
Material]).

I do not understand your statement "I need to have the text from another
field in that table."

I would like to comine several fields of a query into a single field.

My current statement is:

Structure: +[Structure Builder]![Base Layer Amount] & " " & [Structure
Builder]![Base Layer Units] & " " & [Structure Builder]![Base Layer Material]
& "/"


the problem is "Base Layer Material" uses a a bound column which is a
number, I need to have the text from another field in that table. What is the
best way of doing this?