Merging 2 fields in a Append Query

[rjurgens]

I have a query that Appends selected data into the main table. I want to create a key ID field where I merge 2 fields into 1 in order to make a unique number. Any help would be much appreciated.

 

[TonyJollans]

Hi rjurgens,

It depends a little on whether your fields are numbers or text, and exactly how you want to combine them. to simply concatenate them use ..

[blue][tt][ID1]&[ID2][/tt][/blue]

If they are numbers and you want the concatenated result to be a number, you could use ..

[blue][tt]Val([ID1]&[ID2])[/tt][/blue]

But you might have to consider what to do if the numbers are different lengths:

101 & 9 would give 1019
10 & 19 woud also give 1019

In this example, you might want to do ..

[blue][tt]Val([ID1]&Format([ID2],"00&quot)[/tt][/blue]

.. or ..

[blue][tt][ID1]*100+[ID2][/tt][/blue]

.. for example, to return 10109 from 101 and 9

Enjoy,
Tony

------------------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading FAQ222-2244 before you ask a question.

 

[rjurgens]

Thanks Tony. For some reason when I did it the first time, it did not work. Must have mistyped, but it works now. Thanks for taking the time to reply.