Padding a Field

  • Thread starter Thread starter Helen
  • Start date Start date
H

Helen

I am creating a select query and I have a field that
currently contains the value of 10 and I need the field
to be left zero filled so that the value is 0010.

Any ideas.

Thanks
 
I am creating a select query and I have a field that
currently contains the value of 10 and I need the field
to be left zero filled so that the value is 0010.

Any ideas.

Thanks
Click to expand...

I'm not quite sure what you're saying: what's the datatype of the
field in the table? Text or Number? Do you want to pad the criterion
to 0010 (to match a Text field containing that value), or do you want
to retrieve a field containing 10 and display it as 0010?

John W. Vinson[MVP]
(no longer chatting for now)
 
Perhaps you meant:

Right("0000" & [FieldName],4)

--
HTH
Van T. Dinh
MVP (Access)


Chris Nebinger said:
Right("0000" & [FieldName],3)

Chris Nebinger
-----Original Message-----
I am creating a select query and I have a field that
currently contains the value of 10 and I need the field
to be left zero filled so that the value is 0010.

Any ideas.

Thanks
.
Click to expand...
Click to expand...
 
Ooops, minor oversight. Thanks for the correction.

-----Original Message-----
Perhaps you meant:

Right("0000" & [FieldName],4)

--
HTH
Van T. Dinh
MVP (Access)


Right("0000" & [FieldName],3)

Chris Nebinger
-----Original Message-----
I am creating a select query and I have a field that
currently contains the value of 10 and I need the field
to be left zero filled so that the value is 0010.

Any ideas.

Thanks
.
Click to expand...
Click to expand...


.
Click to expand...
 
Back
Top