Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Number Format

Discussion in 'Information Technology' started by Zanstemic, Jul 28, 2006.

Tags:
  1. Zanstemic

    Zanstemic
    Expand Collapse
    Guest

    I have a number that is incrementing that requires the following format:

    001, 002, 003, etc.

    Currently it is formating as 1, 2, 3, etc.

    Any suggestions?
     
  2. Loading...

    Similar Threads Forum Date
    Shabad Numbering System New to Sikhism Dec 1, 2015
    USA A Heart Attack And The Numbers Breaking News Aug 2, 2014
    Pacific Borneo: Sikhs small in number, strong in presence Breaking News Nov 11, 2013
    World Shrinking Numbers and Growing Persecution Threaten Sikhs and Hindus in Afghanistan Breaking News Nov 7, 2013
    SciTech Mammals pick offspring’s sex to maximize number of grandchildren, study shows Breaking News Jul 11, 2013

  3. fredg

    fredg
    Expand Collapse
    Guest

    On Tue, 20 Jun 2006 12:05:02 -0700, Zanstemic wrote:

    > I have a number that is incrementing that requires the following format:
    >
    > 001, 002, 003, etc.
    >
    > Currently it is formating as 1, 2, 3, etc.
    >
    > Any suggestions?


    You can set the Format property of the control to
    000
    which will display 001 (but store 1).
    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     
  4. Ofer Cohen

    Ofer Cohen
    Expand Collapse
    Guest

    What do you expect to get if the number pass the 999?

    --
    Good Luck
    BS"D


    "Zanstemic" wrote:

    > I have a number that is incrementing that requires the following format:
    >
    > 001, 002, 003, etc.
    >
    > Currently it is formating as 1, 2, 3, etc.
    >
    > Any suggestions?
    >
    >
     
  5. Zanstemic

    Zanstemic
    Expand Collapse
    Guest

    1) It did work, however, the number is called in another field so it needs to
    maintain it's value as 000

    2) I only anticipate about 25 since the number recycles each day.

    Any other suggestions?

    "Ofer Cohen" wrote:

    > What do you expect to get if the number pass the 999?
    >
    > --
    > Good Luck
    > BS"D
    >
    >
    > "Zanstemic" wrote:
    >
    > > I have a number that is incrementing that requires the following format:
    > >
    > > 001, 002, 003, etc.
    > >
    > > Currently it is formating as 1, 2, 3, etc.
    > >
    > > Any suggestions?
    > >
    > >
     
  6. fredg

    fredg
    Expand Collapse
    Guest

    On Thu, 22 Jun 2006 10:47:01 -0700, Zanstemic wrote:

    > 1) It did work, however, the number is called in another field so it needs to
    > maintain it's value as 000
    >
    > 2) I only anticipate about 25 since the number recycles each day.
    >
    > Any other suggestions?
    >
    > "Ofer Cohen" wrote:
    >
    >> What do you expect to get if the number pass the 999?
    >>
    >> --
    >> Good Luck
    >> BS"D
    >>
    >> "Zanstemic" wrote:
    >>
    >>> I have a number that is incrementing that requires the following format:
    >>>
    >>> 001, 002, 003, etc.
    >>>
    >>> Currently it is formating as 1, 2, 3, etc.
    >>>
    >>> Any suggestions?
    >>>
    >>>


    Perhaps you miss-understand how Access stores numbers.
    4 is exactly the same value as 004.
    Access, regardless of how you display the number, will always store it
    as 4.
    If you need to display it in another control, you will also have to
    format that control to:
    000

    The only way you will get Access to store a value of 004 is to make
    the field's datatype Text. In that case, Access will store "004" (as
    text, note the quotes).
    You will then need to convert it back to a Number if you intend to
    perform any mathematical calculations with it.
    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     
  7. Zanstemic

    Zanstemic
    Expand Collapse
    Guest

    I'm new to access so my understanding is missed . <smile>

    =Format([RegistrationDate],"yymmdd") & [Registration Case Number]

    Both numbers are displaying correctly in thier unique fields.

    Registration Case Number is the number that requires the 000 format. The
    ultimate number needs to be 9 digits. with the year being the first two,
    month being the second two and the day being the third two followed by 001,
    002,003.

    I've tried to have the [Registration Case Number] be text but it comes out
    as two digits.

    Any suggestions?

    "fredg" wrote:

    > On Thu, 22 Jun 2006 10:47:01 -0700, Zanstemic wrote:
    >
    > > 1) It did work, however, the number is called in another field so it needs to
    > > maintain it's value as 000
    > >
    > > 2) I only anticipate about 25 since the number recycles each day.
    > >
    > > Any other suggestions?
    > >
    > > "Ofer Cohen" wrote:
    > >
    > >> What do you expect to get if the number pass the 999?
    > >>
    > >> --
    > >> Good Luck
    > >> BS"D
    > >>
    > >> "Zanstemic" wrote:
    > >>
    > >>> I have a number that is incrementing that requires the following format:
    > >>>
    > >>> 001, 002, 003, etc.
    > >>>
    > >>> Currently it is formating as 1, 2, 3, etc.
    > >>>
    > >>> Any suggestions?
    > >>>
    > >>>

    >
    > Perhaps you miss-understand how Access stores numbers.
    > 4 is exactly the same value as 004.
    > Access, regardless of how you display the number, will always store it
    > as 4.
    > If you need to display it in another control, you will also have to
    > format that control to:
    > 000
    >
    > The only way you will get Access to store a value of 004 is to make
    > the field's datatype Text. In that case, Access will store "004" (as
    > text, note the quotes).
    > You will then need to convert it back to a Number if you intend to
    > perform any mathematical calculations with it.
    > --
    > Fred
    > Please respond only to this newsgroup.
    > I do not reply to personal e-mail
    >
     
  8. fredg

    fredg
    Expand Collapse
    Guest

    On Thu, 22 Jun 2006 12:03:02 -0700, Zanstemic wrote:

    > I'm new to access so my understanding is missed . <smile>
    >
    > =Format([RegistrationDate],"yymmdd") & [Registration Case Number]
    >
    > Both numbers are displaying correctly in thier unique fields.
    >
    > Registration Case Number is the number that requires the 000 format. The
    > ultimate number needs to be 9 digits. with the year being the first two,
    > month being the second two and the day being the third two followed by 001,
    > 002,003.
    >
    > I've tried to have the [Registration Case Number] be text but it comes out
    > as two digits.
    >
    > Any suggestions?
    >
    > "fredg" wrote:
    >
    >> On Thu, 22 Jun 2006 10:47:01 -0700, Zanstemic wrote:
    >>
    >>> 1) It did work, however, the number is called in another field so it needs to
    >>> maintain it's value as 000
    >>>
    >>> 2) I only anticipate about 25 since the number recycles each day.
    >>>
    >>> Any other suggestions?
    >>>
    >>> "Ofer Cohen" wrote:
    >>>
    >>>> What do you expect to get if the number pass the 999?
    >>>>
    >>>> --
    >>>> Good Luck
    >>>> BS"D
    >>>>
    >>>> "Zanstemic" wrote:
    >>>>
    >>>>> I have a number that is incrementing that requires the following format:
    >>>>>
    >>>>> 001, 002, 003, etc.
    >>>>>
    >>>>> Currently it is formating as 1, 2, 3, etc.
    >>>>>
    >>>>> Any suggestions?
    >>>>>
    >>>>>

    >>
    >> Perhaps you miss-understand how Access stores numbers.
    >> 4 is exactly the same value as 004.
    >> Access, regardless of how you display the number, will always store it
    >> as 4.
    >> If you need to display it in another control, you will also have to
    >> format that control to:
    >> 000
    >>
    >> The only way you will get Access to store a value of 004 is to make
    >> the field's datatype Text. In that case, Access will store "004" (as
    >> text, note the quotes).
    >> You will then need to convert it back to a Number if you intend to
    >> perform any mathematical calculations with it.
    >> --
    >> Fred
    >> Please respond only to this newsgroup.
    >> I do not reply to personal e-mail
    >>


    =Format([RegistrationDate],"yymmdd") & Format([Registration Case
    Number],"000")

    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     
  9. Zanstemic

    Zanstemic
    Expand Collapse
    Guest

    Thanks for the help. It worked like a charm.

    "fredg" wrote:

    > On Thu, 22 Jun 2006 12:03:02 -0700, Zanstemic wrote:
    >
    > > I'm new to access so my understanding is missed . <smile>
    > >
    > > =Format([RegistrationDate],"yymmdd") & [Registration Case Number]
    > >
    > > Both numbers are displaying correctly in thier unique fields.
    > >
    > > Registration Case Number is the number that requires the 000 format. The
    > > ultimate number needs to be 9 digits. with the year being the first two,
    > > month being the second two and the day being the third two followed by 001,
    > > 002,003.
    > >
    > > I've tried to have the [Registration Case Number] be text but it comes out
    > > as two digits.
    > >
    > > Any suggestions?
    > >
    > > "fredg" wrote:
    > >
    > >> On Thu, 22 Jun 2006 10:47:01 -0700, Zanstemic wrote:
    > >>
    > >>> 1) It did work, however, the number is called in another field so it needs to
    > >>> maintain it's value as 000
    > >>>
    > >>> 2) I only anticipate about 25 since the number recycles each day.
    > >>>
    > >>> Any other suggestions?
    > >>>
    > >>> "Ofer Cohen" wrote:
    > >>>
    > >>>> What do you expect to get if the number pass the 999?
    > >>>>
    > >>>> --
    > >>>> Good Luck
    > >>>> BS"D
    > >>>>
    > >>>> "Zanstemic" wrote:
    > >>>>
    > >>>>> I have a number that is incrementing that requires the following format:
    > >>>>>
    > >>>>> 001, 002, 003, etc.
    > >>>>>
    > >>>>> Currently it is formating as 1, 2, 3, etc.
    > >>>>>
    > >>>>> Any suggestions?
    > >>>>>
    > >>>>>
    > >>
    > >> Perhaps you miss-understand how Access stores numbers.
    > >> 4 is exactly the same value as 004.
    > >> Access, regardless of how you display the number, will always store it
    > >> as 4.
    > >> If you need to display it in another control, you will also have to
    > >> format that control to:
    > >> 000
    > >>
    > >> The only way you will get Access to store a value of 004 is to make
    > >> the field's datatype Text. In that case, Access will store "004" (as
    > >> text, note the quotes).
    > >> You will then need to convert it back to a Number if you intend to
    > >> perform any mathematical calculations with it.
    > >> --
    > >> Fred
    > >> Please respond only to this newsgroup.
    > >> I do not reply to personal e-mail
    > >>

    >
    > =Format([RegistrationDate],"yymmdd") & Format([Registration Case
    > Number],"000")
    >
    > --
    > Fred
    > Please respond only to this newsgroup.
    > I do not reply to personal e-mail
    >
     

Share This Page