RE: Seting format to be 000000000000000

Further to my last post, because you have this in the query section, add
columns to your query to do the same job

Padded1: Right("00000000000000" & [YourField],14)

"Beth" wrote:

> Hello Everyone,
>
> I have got a field called "amount".
>
> Currently it holds the following values 61025, 68653 etc
>
> Is there any built in function which I can use to fill the field with
> leading zeros?
>
> Eg so it displays 00000000061025, 00000000068653.
>
> Ideally I want to do this in a query without any manual steps as it will be
> run by end users.
>
> Kind Regards,
> Beth
.

Relevant Pages

  • "Did use to be" or "did used to be"?
    ... If you want to query someone whether it commonly was as cold as it is ... Kind regards, ... Prev by Date: ...
    (alt.usage.english)
  • Re: True/False : 1/0
    ... Kind regards, ... > I'm sure this is a simple query, but can you convert true/false returns ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • RE: Seting format to be 000000000000000
    ... You can try the following in your query or on a report: ... "Beth" wrote: ... > Kind Regards, ...
    (microsoft.public.access.queries)
  • RE: Seting format to be 000000000000000
    ... "Beth" wrote: ... > Ideally I want to do this in a query without any manual steps as it will be ... > Kind Regards, ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: database engine does not recognize as valid field name
    ... The name of the field in your query is Quarters: use that instead of "Qtr " ... "Beth" wrote in message ... > crosstab queries. ... > I get a run time error 3070 does not recognize for the date. ...
    (microsoft.public.access.forms)
Quantcast