Hello-
I need to join 3 fields together to make New field.
Field 1 = 1
Field 2 = 22
Field 3 = 5
New Field = 1225
Thanks
Jeannette's given you the answer... but let me give you a question.
WHY?
Storing data redundantly is a bad idea.
Storing data redundantly and ambiguously is an even WORSE idea: what result do
you want if Field1 is 12, Field2 is 2, and Field3 is 5? Is it OK that it gives
you exactly the same result as your example? It will do so.
What's the context? It may be legitimate to do this... but you're tiptoeing
through a minefield.