Append only part of field record

[lassang01]

I have an MS Access DB and I want to run an append query that can only
append a part of specific field.
I my case field "X" in DB1 have all values starting with (166-) for
example 166-1235, 166-1234...etc
What I would like is that I could only append the values 1235,
1234...etc to field"Y" in DB2.
I hope I will get assistance.
Thanks in advance.

 

[Marshall Barton]

I have an MS Access DB and I want to run an append query that can only
append a part of specific field.
I my case field "X" in DB1 have all values starting with (166-) for
example 166-1235, 166-1234...etc
What I would like is that I could only append the values 1235,
1234...etc to field"Y" in DB2.

In the Select part of the append query, use an expression
like Mid(X, 5) instead of just X

 

[lassang01]

In the Select part of the append query, use an expression
like Mid(X, 5) instead of just X

That worked very fine, Thanks a lot

 

[raskew via AccessMonster.com]

Or, if the length of the first part of the string can very:

x = "166-1234"
y = val(mid(x, Instr(x, "-")+1))
? y
1234

Bob