Updating a Value in an Empty field [200 Records]

[Maillme]

Hi there,

I have a table with 2000 records,

i want to create a new field called "Name"

I want this to be equal to the value from "label" & "artist"

So, if:

label = 1
artist = Test

I want Name = 1 Test

I have imported my data, and have added the "Name" field - but i now want to update this field to include the above, but don't know how.

Access 2003.

many thanks,
Neil

 

[dhookom]

First, why do you want to add a field that can be calculated from two other fields. This is generally considered bad practice.

Second, if you [red]really[/red] need to do this, change the name of the name field from name to something that is more descriptive and isn't a reserved word. Perhaps [LabArt].

If you want to do this once, create an update query t

UPDATE [with 2000 records]
SET LabArt = [label] & [artist]
WHERE LabArt Is Null;

[red]Again, I wouldn't do this.[/red]

Duane
Hook'D on Access
MS Access MVP

 

[Maillme]

hi there,

thanks for the reply.

The reason im doing it is because i want to export the date from my database to a csv file, which will then update an online shop.

I need to "join" the 2 fields to make the title of my product.

thanks again,
Neil

 

[dhookom]

You can export a query to CSV rather than a table. The query can contain the concatenated value. It doesn't have to be stored in the table.

Duane
Hook'D on Access
MS Access MVP

 

[lespaul]

So in your query you do:

SELECT [label] & [artist] as LabArt From TableName

then export the query as Duane suggests....




Leslie

Have you met Hardy Heron?