Combining Colums

[mikeinohio]

I have a existing database with a table in it called parts, and in this table
there is a column called word one and one called word two, i need the
information in both of these columns in one column together if there is a
way can someone enlighten me on this procedure

 

[Smartin]

I have a existing database with a table in it called parts, and in this table
there is a column called word one and one called word two, i need the
information in both of these columns in one column together if there is a
way can someone enlighten me on this procedure

Create a query thus:

SELECT P.[word one] & P.[word two] AS OneColumn
FROM parts AS P;

HTH

 

[mikeinohio]

where do i do this?

I have a existing database with a table in it called parts, and in this table
there is a column called word one and one called word two, i need the
information in both of these columns in one column together if there is a
way can someone enlighten me on this procedure

Create a query thus:

SELECT P.[word one] & P.[word two] AS Description
FROM parts AS Description;

HTH

 

[John W. Vinson]

I have a existing database with a table in it called parts, and in this table
there is a column called word one and one called word two, i need the
information in both of these columns in one column together if there is a
way can someone enlighten me on this procedure

To expand on smartins's correct answer:

Create a Query based on the table. Select whatever fields you want to
see in the query.

In a vacant Field cell type

BothWords: [Word one] & [Word two]

If Word 1 contains "Large" and Word 2 contains "Small", this will give
you "LargeSmall" as a calculated field named BothWords.

If you want a blank between them use

BothWords: [Word one] & " " & [Word two]


John W. Vinson [MVP]