Padding a Field

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
 
J

John Vinson

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)
 
V

Van T. Dinh

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...
 
Top