Combining Colums

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
mikeinohio said:
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
Click to expand...

Create a query thus:

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

HTH
 
where do i do this?

Smartin said:
mikeinohio said:
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
Click to expand...

Create a query thus:

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

HTH
Click to expand...
 
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
Click to expand...

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]
 
Back
Top