CONCATENATE

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

How Can I combine two fields into one
for example:
field 1 field2
CA 100

output:
CA100

Anybody know how I do in ACCess.

thanks
Tony
 
Hi Tony

if you're using a query this goes in the top line of the query grid
where newfield is what you want to call your "new field"

newfield: [field 1] & [field 2]

if you want to do it in a unbound text box on a form then in the control
source of the text box put
=[field 1] & [field 2]

Hope this helps
Cheers
JulieD
 
it works, thanks
-----Original Message-----
Hi Tony

if you're using a query this goes in the top line of the query grid
where newfield is what you want to call your "new field"

newfield: [field 1] & [field 2]

if you want to do it in a unbound text box on a form then in the control
source of the text box put
=[field 1] & [field 2]

Hope this helps
Cheers
JulieD


How Can I combine two fields into one
for example:
field 1 field2
CA 100

output:
CA100

Anybody know how I do in ACCess.

thanks
Tony
Click to expand...


.
Click to expand...
 
Back
Top