Number field do alfa numeric update

[Panchovia]

I have a old table with numeric field now I create a new table it must be changed to alfa
numeric, format ---[99999]

I created a update query to update the numeric field to the new table with the info of the old table without any success.

Any suggestions.

 

[dhookom]

Can you provide the table and field names and data types? How about some sample records? What did you try? What do you mean by "without any success"?


Duane
Hook'D on Access
MS Access MVP

 

[Panchovia]

example ;

Old database clientnumber; clientname etc.

1 Pancho via
2 Napaloen

New database;

DF-1 Pancho via
DF-2 Napoloen etc

code used in query

update field DF-+[clientnumber]
is this correct

 

[Panchovia]

correction:

Code used in query New database client number field
Update ; "DF-"+[Olddatabase]![clientnumber]

 

[traingamer]

That should work if the field in the new table is a string.

Try using an ampersand for string concatenation:

"DF-" [red]&[/red] [Olddatabase]![clientnumber]

Greg
People demand freedom of speech as a compensation for the freedom of thought which they seldom use. Kierkegaard