Merge two record in two different column in one column with space between

I have one column with surname, the other with name. Ho to metge into
a different one Surname Name?
Thanks

Nov 13 '05 #1

1274

You can do it in a query. I don't recommend creating a table from the
query because you may want to split them up again.

Creat a calculated field in your query and call it FullName

In the query grid it would be FullName:[Name] &" "& [Surname]

or if you want it reversed

FullName:[Surname] &" "& [Name]

Sharp <sh***@park.it> wrote in message news:<15********************************@4ax.com>. ..

I have one column with surname, the other with name. Ho to metge into
a different one Surname Name?
Thanks

Nov 13 '05 #2

Pieter Linden

Sharp <sh***@park.it> wrote in message news:<15********************************@4ax.com>. ..

I have one column with surname, the other with name. Ho to metge into
a different one Surname Name?
Thanks

use a query and join the two tables on a common field with unique
values... then you could create an expression...
FullName: FirstName & " " & Surname

Nov 13 '05 #3

Sharp

On 30 Jul 2004 12:41:37 -0700, du********@aol.com (Ed Marzan) wrote:

You can do it in a query. I don't recommend creating a table from the
query because you may want to split them up again.

Creat a calculated field in your query and call it FullName

In the query grid it would be FullName:[Name] &" "& [Surname]

or if you want it reversed

FullName:[Surname] &" "& [Name]

Sharp <sh***@park.it> wrote in message news:<15********************************@4ax.com>. ..
I have one column with surname, the other with name. Ho to metge into
a different one Surname Name?
Thanks

Thanks

Nov 13 '05 #4

Sharp

On 30 Jul 2004 14:59:00 -0700, pi********@hotmail.com (Pieter Linden)
wrote:

Sharp <sh***@park.it> wrote in message news:<15********************************@4ax.com>. ..
I have one column with surname, the other with name. Ho to metge into
a different one Surname Name?
Thanks

use a query and join the two tables on a common field with unique
values... then you could create an expression...
FullName: FirstName & " " & Surname

Thanks

Nov 13 '05 #5

Similar topics

MS Word mail merge automation

by: Steve M | last post by:

I'm trying to do invoke the mail merge functionality of MS Word from a Python script. The situation is that I have a template Word document, and a record that I've generated in Python, and I want...

Python

Merge does not work on 8.1.0

by: Sebastian Luemmer | last post by:

Hi, I have developed an SQL-Script which I tested successfully on DB2 v8.1.3.132 (SQL08013). When I tried to run the script on a DB2 v8.1.0.36 (SQL08010) the script failed with the message ...

DB2 Database

Making the same data in one table, with same name, appear automatically in another table and form for record integrity and adding extra information

by: Sami | last post by:

Please bear with me, and if you answer this question, please do it step by step. I am new at Access, not at all sophisticated. I am using Office XP. This will need to be read in Access for...

Microsoft Access / VBA

Seg faults in merge and quick sort

by: ralphedge | last post by:

These sorts work fine on 100000 ints but if I go much higher they will both segmentation fault **************************MERGESORT********************* mergesort(int *a, int size) //a is...

C / C++

Merge Replication and Trigger Problem

by: Benzine | last post by:

Hi, I have an issue with my replication at the moment. I will try to describe the scenario accurately. I am using MS SQL 2000 SP4 with Merge Replication. Subscribers connect to the publisher...

Microsoft SQL Server

Column names for customized query and merge

by: christianlott1 | last post by:

I want to provide users with an interface to create a custom merge (all in Access, not Word). User will put in a set of brackets ("<>") in a memo field and when they click the merge button it will...

Microsoft Access / VBA

Mail merge to Word

by: giladp1 | last post by:

I found Albert Kallal's great "Super easy Word Merge" code in his site at: http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html Thanks Albert so much for sharing this. I am looking...

Microsoft Access / VBA

Breaking out a record with in a datagrid to edit it (ASP 1)

by: =?Utf-8?B?bWlrZWc=?= | last post by:

Hi, I am building a small Help Desk application for my company and need to be able to edit "open" help desk issues. I use a simple datagrid to display each issue (6 per page) , with an Edit...

ASP.NET

Regarding concurrency MERGE x UPDATE

by: Michel Esber | last post by:

Hi all, DB2 V8 LUW FP 15 There is a table T (ID varchar (24), ABC timestamp). ID is PK. Our application needs to frequently update T with a new value for ABC. update T set ABC=? where ID...

DB2 Database

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math