Concatenate Function

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

Guest

I have probably a relatively easy question that I just can't figure out the
answer to. I have a field of data that reads like this

01129208

What I would like to do is add a zero on the end to have it read 011292080

I know in Excel there is a concatenate function I can do this with, but does
something similiar exist in MS Access?
 
Bob said:
I have probably a relatively easy question that I just can't figure out the
answer to. I have a field of data that reads like this

01129208

What I would like to do is add a zero on the end to have it read 011292080

I know in Excel there is a concatenate function I can do this with, but does
something similiar exist in MS Access?
Click to expand...


Actually I figured it out by typing the 01129208 + "0"...I knew it was in my
head somewhere
 
I'd recommend using & for concatenation, to ensure that Access doesn't get
confused and treat it as adding zero to the number.
 
Back
Top