merge two fields in access? how to ?

[vivah]

Hello,



I need help merge two fields in access, and paste into third field , how to ?
image attached.

i want to merge "software name" with "version" and paste the results to "software_version".

thanks so much,

vivah

[R_Badger]

I would use a query

in the software version try:

=[software name] &" " & [version]

[RuralGuy]

You can *always* put them together whenever needed in a query. I would recommend *not* putting them together in a field. Fields in a Relational DataBase Table should *not* be dependant on other fields in the same table.

[vivah]

pls elaborate , i didn't understand,
how do i create another table and paste the results ? then,

[RuralGuy]

Why do you feel you need them put together in another table? The information in a nornalzed RDMS should *only* exist in one place in the system. As I said, you can always put them together in a query.

[vivah]

ok same table is fine, but sorry, i don't understand where i put your below statement, ( can you pls give me the full sql statment for this, thanks)
=[software name] &" " & [version]

[RuralGuy]

SELECT [software name] &" " & [version] AS FullName FROM YourTable