Simple concatenation of fields

[Guest]

Hello, I have a table and one of the fields is a lookup which I'm basing on a
query. The field in the table is called software ID which is a number but
instead of displaying the number of the software ID, the query pulls from two
other tables that lists the manufacturer of the software and then a
description of the software. For instance, one table is called software
companies and within that table there is the company name (e.g. Adobe
Systems). Another table is called software products and within that table is
a description of each piece of software we have. (e.g. Acrobat). So the
query pulls the company name plus the software description. I would like the
result to look like: Adobe Systems - Acrobat Full, but I can't get the "-"
into the query without coding it. Is there a simpler way to concatenate
within the query itself? Thank you.

 

[Guest]

What do you mean by "coding it"? Did you try an expression in your query like:
CompSoftware: [CompanyName] & " - " & [Software Description]

 

[Guest]

I'm afraid I wasn't very clear. I would like the query to display 3 fields
from one table as one field in the lookup, then place the chosen information
into one field in the "many" table. For instance, I have a table called
tblSoftwareInventory which lists all software by:
Company Name Software Name Software Version
I would like these three fields to display togehter in a drop down list
within another table called tblSoftware Product. When the user picks from
the list I would like all three fields to be entered as one field called
Software Description in tblSoftwareProduct. I hope this makes more sense.

What do you mean by "coding it"? Did you try an expression in your query like:
CompSoftware: [CompanyName] & " - " & [Software Description]
--
Duane Hookom
Microsoft Access MVP

Hello, I have a table and one of the fields is a lookup which I'm basing on a
query. The field in the table is called software ID which is a number but
instead of displaying the number of the software ID, the query pulls from two
other tables that lists the manufacturer of the software and then a
description of the software. For instance, one table is called software
companies and within that table there is the company name (e.g. Adobe
Systems). Another table is called software products and within that table is
a description of each piece of software we have. (e.g. Acrobat). So the
query pulls the company name plus the software description. I would like the
result to look like: Adobe Systems - Acrobat Full, but I can't get the "-"
into the query without coding it. Is there a simpler way to concatenate
within the query itself? Thank you.

 

[Guest]

To display all three columns in a drop-down in a form, make sure your combo
box row source has a column based on:
[Company Name] & " " & [Software Name] & " " & [Software Version]
If you want this stored in another table (generally not a good idea) set
this column as the bound column and set the Control Source of the combo box
to the field in the "another table".

--
Duane Hookom
Microsoft Access MVP

I'm afraid I wasn't very clear. I would like the query to display 3 fields
from one table as one field in the lookup, then place the chosen information
into one field in the "many" table. For instance, I have a table called
tblSoftwareInventory which lists all software by:
Company Name Software Name Software Version
I would like these three fields to display togehter in a drop down list
within another table called tblSoftware Product. When the user picks from
the list I would like all three fields to be entered as one field called
Software Description in tblSoftwareProduct. I hope this makes more sense.

What do you mean by "coding it"? Did you try an expression in your query like:
CompSoftware: [CompanyName] & " - " & [Software Description]
--
Duane Hookom
Microsoft Access MVP

Hello, I have a table and one of the fields is a lookup which I'm basing on a
query. The field in the table is called software ID which is a number but
instead of displaying the number of the software ID, the query pulls from two
other tables that lists the manufacturer of the software and then a
description of the software. For instance, one table is called software
companies and within that table there is the company name (e.g. Adobe
Systems). Another table is called software products and within that table is
a description of each piece of software we have. (e.g. Acrobat). So the
query pulls the company name plus the software description. I would like the
result to look like: Adobe Systems - Acrobat Full, but I can't get the "-"
into the query without coding it. Is there a simpler way to concatenate
within the query itself? Thank you.

 

[Guest]

Hello,
Yes, I was already using the correct row source but it's only for the drop
down list. What is actually placed in the field in the table is just the
firs field, i.e. company name. Can you tell me why it's not a good idea to
do this?

Thank you.

To display all three columns in a drop-down in a form, make sure your combo
box row source has a column based on:
[Company Name] & " " & [Software Name] & " " & [Software Version]
If you want this stored in another table (generally not a good idea) set
this column as the bound column and set the Control Source of the combo box
to the field in the "another table".

--
Duane Hookom
Microsoft Access MVP

I'm afraid I wasn't very clear. I would like the query to display 3 fields
from one table as one field in the lookup, then place the chosen information
into one field in the "many" table. For instance, I have a table called
tblSoftwareInventory which lists all software by:
Company Name Software Name Software Version
I would like these three fields to display togehter in a drop down list
within another table called tblSoftware Product. When the user picks from
the list I would like all three fields to be entered as one field called
Software Description in tblSoftwareProduct. I hope this makes more sense.

What do you mean by "coding it"? Did you try an expression in your query like:
CompSoftware: [CompanyName] & " - " & [Software Description]
--
Duane Hookom
Microsoft Access MVP


:

Hello, I have a table and one of the fields is a lookup which I'm basing on a
query. The field in the table is called software ID which is a number but
instead of displaying the number of the software ID, the query pulls from two
other tables that lists the manufacturer of the software and then a
description of the software. For instance, one table is called software
companies and within that table there is the company name (e.g. Adobe
Systems). Another table is called software products and within that table is
a description of each piece of software we have. (e.g. Acrobat). So the
query pulls the company name plus the software description. I would like the
result to look like: Adobe Systems - Acrobat Full, but I can't get the "-"
into the query without coding it. Is there a simpler way to concatenate
within the query itself? Thank you.

 

[Guest]

If your combo box isn't working, come back with:
Name:
Row Source:
Control Source:
Bound Column:
Column Count:
Column Widths:

You should generally use primary and foreign keys in your tables so that
"descriptive" type fields have this value stored in only one record in one
table in one field.
--
Duane Hookom
Microsoft Access MVP

Hello,
Yes, I was already using the correct row source but it's only for the drop
down list. What is actually placed in the field in the table is just the
firs field, i.e. company name. Can you tell me why it's not a good idea to
do this?

Thank you.

To display all three columns in a drop-down in a form, make sure your combo
box row source has a column based on:
[Company Name] & " " & [Software Name] & " " & [Software Version]
If you want this stored in another table (generally not a good idea) set
this column as the bound column and set the Control Source of the combo box
to the field in the "another table".

--
Duane Hookom
Microsoft Access MVP

I'm afraid I wasn't very clear. I would like the query to display 3 fields
from one table as one field in the lookup, then place the chosen information
into one field in the "many" table. For instance, I have a table called
tblSoftwareInventory which lists all software by:
Company Name Software Name Software Version
I would like these three fields to display togehter in a drop down list
within another table called tblSoftware Product. When the user picks from
the list I would like all three fields to be entered as one field called
Software Description in tblSoftwareProduct. I hope this makes more sense.

:

What do you mean by "coding it"? Did you try an expression in your query like:
CompSoftware: [CompanyName] & " - " & [Software Description]
--
Duane Hookom
Microsoft Access MVP


:

Hello, I have a table and one of the fields is a lookup which I'm basing on a
query. The field in the table is called software ID which is a number but
instead of displaying the number of the software ID, the query pulls from two
other tables that lists the manufacturer of the software and then a
description of the software. For instance, one table is called software
companies and within that table there is the company name (e.g. Adobe
Systems). Another table is called software products and within that table is
a description of each piece of software we have. (e.g. Acrobat). So the
query pulls the company name plus the software description. I would like the
result to look like: Adobe Systems - Acrobat Full, but I can't get the "-"
into the query without coding it. Is there a simpler way to concatenate
within the query itself? Thank you.