concatenate names

  • Thread starter Thread starter shaloy
  • Start date Start date
S

shaloy

Hi ,

I have 20,000 records with blank names,wherever i find a record with a no
name i want to fill those records with the information from my second coulmn.
is this possible if so can someone guide me please

Something similar to concatenate function in excel!


Thanks
Shankar
 
If you want to permanently change the contents then you could use an
update query.

STEP 1: BACKUP your data before attempting the following.
STEP 2: BACKUP your data before attempting the following.

Without a backup you cannot restore the data if this does not work the
way you expect.
 
Strange that is the second time recently that my response has been
truncated.

You need to use an update query.

In query design view
++ Add your table
++ Add the field you want to fix
++ Type the following as criteria for the field
IS NULL
++ Select Query: Update from the menu
++ In the Update to block enter the following with the brackets
[NameOfYourTable].[NameOfYourSourceField]
++ Select Query: Run from the menu

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
hi john ,

thnx for the response ...i hve got 80,00 records intially but wil try yours
and by you know by monday !

i did try an example out ,it seems to like do what it intends to but in the
new query that i have created it does not disply the information of the
original column.(i.e. the the one which i originally used to concatenate the
second column)

any ideas .thanks

thanks for the help
cheers
shankar

John Spencer said:
Strange that is the second time recently that my response has been
truncated.

You need to use an update query.

In query design view
++ Add your table
++ Add the field you want to fix
++ Type the following as criteria for the field
IS NULL
++ Select Query: Update from the menu
++ In the Update to block enter the following with the brackets
[NameOfYourTable].[NameOfYourSourceField]
++ Select Query: Run from the menu

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================


John said:
If you want to permanently change the contents then you could use an
update query.

STEP 1: BACKUP your data before attempting the following.
STEP 2: BACKUP your data before attempting the following.

Without a backup you cannot restore the data if this does not work the
way you expect.
Click to expand...
Click to expand...
 
hi john,

sorry ignore my previous post i was being too dumb .. its work absolutely
fine ..

thanks
shankr

shaloy said:
hi john ,

thnx for the response ...i hve got 80,00 records intially but wil try yours
and by you know by monday !

i did try an example out ,it seems to like do what it intends to but in the
new query that i have created it does not disply the information of the
original column.(i.e. the the one which i originally used to concatenate the
second column)

any ideas .thanks

thanks for the help
cheers
shankar

John Spencer said:
Strange that is the second time recently that my response has been
truncated.

You need to use an update query.

In query design view
++ Add your table
++ Add the field you want to fix
++ Type the following as criteria for the field
IS NULL
++ Select Query: Update from the menu
++ In the Update to block enter the following with the brackets
[NameOfYourTable].[NameOfYourSourceField]
++ Select Query: Run from the menu

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================


John said:
If you want to permanently change the contents then you could use an
update query.

STEP 1: BACKUP your data before attempting the following.
STEP 2: BACKUP your data before attempting the following.

Without a backup you cannot restore the data if this does not work the
way you expect.
Click to expand...
Click to expand...
Click to expand...
 
If you mean you clicked on Datasheet view and you didn't see the source
column, that is perfectly understandable.

When you switch an update query to datasheet view from design view, the
update query doesn't execute, it only shows the existing values that
will be updated. Also, it only shows the columns that will be updated
and no other columns. Since you are not updating the source column,
then it won't be displayed.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

hi john ,

thnx for the response ...i hve got 80,00 records intially but wil try yours
and by you know by monday !

i did try an example out ,it seems to like do what it intends to but in the
new query that i have created it does not disply the information of the
original column.(i.e. the the one which i originally used to concatenate the
second column)

any ideas .thanks

thanks for the help
cheers
shankar

John Spencer said:
Strange that is the second time recently that my response has been
truncated.

You need to use an update query.

In query design view
++ Add your table
++ Add the field you want to fix
++ Type the following as criteria for the field
IS NULL
++ Select Query: Update from the menu
++ In the Update to block enter the following with the brackets
[NameOfYourTable].[NameOfYourSourceField]
++ Select Query: Run from the menu

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================


John said:
If you want to permanently change the contents then you could use an
update query.

STEP 1: BACKUP your data before attempting the following.
STEP 2: BACKUP your data before attempting the following.

Without a backup you cannot restore the data if this does not work the
way you expect.
Click to expand...
Click to expand...
Click to expand...
 
well I tried the query wit only one column that i needed to update in the
query and then switched to the table which has obviously done the work !

i really dont know y had i posted tht probably i was a bit impatient in
trying out what you had suggested !

and what if wanted to subsitute a standard text before i actually i run
this update query on my intended records with blank names ?

anyways thanks for the help ..

thanks
shankar

John Spencer said:
If you mean you clicked on Datasheet view and you didn't see the source
column, that is perfectly understandable.

When you switch an update query to datasheet view from design view, the
update query doesn't execute, it only shows the existing values that
will be updated. Also, it only shows the columns that will be updated
and no other columns. Since you are not updating the source column,
then it won't be displayed.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

hi john ,

thnx for the response ...i hve got 80,00 records intially but wil try yours
and by you know by monday !

i did try an example out ,it seems to like do what it intends to but in the
new query that i have created it does not disply the information of the
original column.(i.e. the the one which i originally used to concatenate the
second column)

any ideas .thanks

thanks for the help
cheers
shankar

John Spencer said:
Strange that is the second time recently that my response has been
truncated.

You need to use an update query.

In query design view
++ Add your table
++ Add the field you want to fix
++ Type the following as criteria for the field
IS NULL
++ Select Query: Update from the menu
++ In the Update to block enter the following with the brackets
[NameOfYourTable].[NameOfYourSourceField]
++ Select Query: Run from the menu

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================


John Spencer wrote:
If you want to permanently change the contents then you could use an
update query.

STEP 1: BACKUP your data before attempting the following.
STEP 2: BACKUP your data before attempting the following.

Without a backup you cannot restore the data if this does not work the
way you expect.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top