Combine two columns into one

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two columns in a table that I need to combine into one.

Region column (number)
District column (number)

need a District 1 column that is made up of the two columns above. I also
have to have the third character as a 0 (zero). Can someone please help?

Thanks,
 
In a new column, put....

District1: [Region] & "0" & [District]


Hope that helps,

Rick B
 
Back
Top