leading zeros combined with strings

[lsm]

Hi everybody,



even if i am one of the new members of this board i am hoping to get some help...

Actually it is an easy problem i guess, even though i did not find a solution googling for quite a while...
I have a table with (integer) numbers! using the format "00000" i can make sure that it will be 5 digits.

No i am aiming to combine the five digit number with a text in another column and do not succed at all.

what i want to get:
column A: number (e.g. 1)
column B: number 4 digits (e.g. 0001)
column C: number combined with string (e.g. ab0001cd)


of course it would be a nice one to skip the coluimn B! - what ever i tried ended up in sth. like "ab1cd" at the best....

any ideas? - maybe it is a really easy one, but i am quite new to access...

thanks a bunch

lsm

[pbaldy]

"ab" & Format(ColumnA, "00000") & "cd"

[lsm]

well thanks for the fast replay... - that's what i tried before, but it does not work.... maybe there is an (easy) stupid mistake i do...
so what i do....
1) craete a new table
2) add a column with number and call it "numbers"
3) add another column by choosing "calculate field - text" (if not exactly correct - sorry i am using the german version...) and add the following: "ab" & Format([numbers], "00000") & "cd" as a command

->Trying to hit "OK" ends up getting an error telling me the syntax is wrong.

what have i done wrong??

[June7]

Calculated field in table does not recognize all functions. Format is not one. Can't do this in table. Must be in query or in textbox on form/report.

[pbaldy]

Welcome to the site. I'll stay out of the way.

[lsm]

oh i see... well thx a bunch!!! now i understand why it did not work out...