Joining two fields to make one

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

Guest

I have Field A in Table A and Field B in Table B. The two tables are joined
via fields A and B, but when creating the new table from a make table query,
I need fields A and B to be joined into one field in the resulting table. Can
do this in Excel with something like Field A&" "&Field B, but not in Access.

Any help appreciated....
 
What are you trying to do? Are you permanently getting rid of table A and
Table B to create Table C?

If not, then you do not need to create table C. You should, instead, create
a query that will pull the data you need.

To combine two fields, you would add a new column to your query with the
following...

SomeNewName: [FieldA] & " " & [FieldB]

Again, it is not likely that you need to be storing this in a new table. If
these are first and last names, for example, then you would simply combine
them in your queries, reports, and forms, but would not create a new table.
 
Back
Top