Adding zero to text field types

N

NPEZP

I have a field that I need to add zero in front of existing data for each
record.
Example: Current New
362957 00362957
89534 00089534
1293456 01293456

Can I set the Format line to add the currect number of zeros if the Field
Type is "TEXT"?
 
N

NPEZP

I tried an update query and typed >> right("00000000"&[textfield],8) << this
expression in the update to row. When I told it to run, there was no change
to my original table. I did substitue my field name for [textfield].


Marvin P. Winterbottom said:
=right("00000000"&[textfield],8)

NPEZP said:
I have a field that I need to add zero in front of existing data for each
record.
Example: Current New
362957 00362957
89534 00089534
1293456 01293456

Can I set the Format line to add the currect number of zeros if the Field
Type is "TEXT"?
Click to expand...
Click to expand...
 
N

NPEZP

Disreguard the previous reply message. I was able to get the update query to
run successfully. Thank you for your assistance.
 
K

Klam

This is excatly what I want but I could not create the Updatee query - can
you show me in more details how you set it up
Ken
--
klam


NPEZP said:
I tried an update query and typed >> right("00000000"&[textfield],8) << this
expression in the update to row. When I told it to run, there was no change
to my original table. I did substitue my field name for [textfield].


Marvin P. Winterbottom said:
=right("00000000"&[textfield],8)

NPEZP said:
I have a field that I need to add zero in front of existing data for each
record.
Example: Current New
362957 00362957
89534 00089534
1293456 01293456

Can I set the Format line to add the currect number of zeros if the Field
Type is "TEXT"?
Click to expand...
Click to expand...
Click to expand...
 
K

Klatuu

It is as simple as:
Format([FieldName], "00000000")

Klam said:
This is excatly what I want but I could not create the Updatee query - can
you show me in more details how you set it up
Ken
--
klam


NPEZP said:
I tried an update query and typed >> right("00000000"&[textfield],8) <<
this
expression in the update to row. When I told it to run, there was no
change
to my original table. I did substitue my field name for [textfield].


Marvin P. Winterbottom said:
=right("00000000"&[textfield],8)

:

I have a field that I need to add zero in front of existing data for
each
record.
Example: Current New
362957 00362957
89534 00089534
1293456 01293456

Can I set the Format line to add the currect number of zeros if the
Field
Type is "TEXT"?
Click to expand...
Click to expand...
Click to expand...
 
Top