Hi all,

Please help for converting a numeric variable to a character variable in
access. Thank you.

I have a variable name ID, it is a numeric variable,
89
90
11123
.........
I would like to convert it to a character, if it less than five digits, then
I need have 0s added at the beginning. it should show up like:
00089
00090
11123
.........

Please help, thank you,

Blinda

Try

Format([variable], "00000")


--
Good Luck
BS"D


"Blinda" wrote:

> Hi all,
>
> Please help for converting a numeric variable to a character variable in
> access. Thank you.
>
> I have a variable name ID, it is a numeric variable,
> 89
> 90
> 11123
> ........
> I would like to convert it to a character, if it less than five digits, then
> I need have 0s added at the beginning. it should show up like:
> 00089
> 00090
> 11123
> ........
>
> Please help, thank you,
>
> Blinda
>
>
>
>

Cohen,

Thank you. I can change the numeric variable to the format of "00089", but
it is still number not a character. I did that in the table: design view-->
format--->\00000

If you know how to change it to character, please show me. Thanks.

Blinda

"Ofer Cohen" wrote:

> Try
>
> Format([variable], "00000")
>
>
> --
> Good Luck
> BS"D
>
>
> "Blinda" wrote:
>
> > Hi all,
> >
> > Please help for converting a numeric variable to a character variable in
> > access. Thank you.
> >
> > I have a variable name ID, it is a numeric variable,
> > 89
> > 90
> > 11123
> > ........
> > I would like to convert it to a character, if it less than five digits, then
> > I need have 0s added at the beginning. it should show up like:
> > 00089
> > 00090
> > 11123
> > ........
> >
> > Please help, thank you,
> >
> > Blinda
> >
> >
> >
> >

Blinda,

There is a VisualBasic-function CStr that converts almost any variable
to text.

Hbinc.



Blinda schreef:

> Cohen,
>
> Thank you. I can change the numeric variable to the format of "00089", but
> it is still number not a character. I did that in the table: design view-->
> format--->\00000
>
> If you know how to change it to character, please show me. Thanks.
>
> Blinda
>
> "Ofer Cohen" wrote:
>
> > Try
> >
> > Format([variable], "00000")
> >
> >
> > --
> > Good Luck
> > BS"D
> >
> >
> > "Blinda" wrote:
> >
> > > Hi all,
> > >
> > > Please help for converting a numeric variable to a character variable in
> > > access. Thank you.
> > >
> > > I have a variable name ID, it is a numeric variable,
> > > 89
> > > 90
> > > 11123
> > > ........
> > > I would like to convert it to a character, if it less than five digits, then
> > > I need have 0s added at the beginning. it should show up like:
> > > 00089
> > > 00090
> > > 11123
> > > ........
> > >
> > > Please help, thank you,
> > >
> > > Blinda
> > >
> > >
> > >
> > >