Welcome to SPN

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

Sign Up Now!

What field type do i use to in put a number 11 digits long?

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

  1. Hassalls

    Hassalls
    Expand Collapse
    Guest

    I want to create a contacts database and i would like to insert an ABN for
    certain contacts.

    What field type do i use?

    I have tried integer and long integer but they say that the data is not the
    right type.
     
  2. Loading...


  3. Dirk Goldgar

    Dirk Goldgar
    Expand Collapse
    Guest

    "Hassalls" <Hassalls@discussions.microsoft.com> wrote in message
    news:CA3D64BD-AD72-49A3-8E59-E8D339C13E6A@microsoft.com
    > I want to create a contacts database and i would like to insert an
    > ABN for certain contacts.
    >
    > What field type do i use?
    >
    > I have tried integer and long integer but they say that the data is
    > not the right type.


    What's an ABN? If it's not a number you're going to do math with, just
    use a Text field. You can set a validation rule forcing it to be all
    numeric digits, if you like.

    --
    Dirk Goldgar, MS Access MVP
    www.datagnostics.com

    (please reply to the newsgroup)
     
  4. Hassalls

    Hassalls
    Expand Collapse
    Guest

    An ABN is short for Austrailian Business Number.

    thanks dirk

    "Dirk Goldgar" wrote:

    > "Hassalls" <Hassalls@discussions.microsoft.com> wrote in message
    > news:CA3D64BD-AD72-49A3-8E59-E8D339C13E6A@microsoft.com
    > > I want to create a contacts database and i would like to insert an
    > > ABN for certain contacts.
    > >
    > > What field type do i use?
    > >
    > > I have tried integer and long integer but they say that the data is
    > > not the right type.

    >
    > What's an ABN? If it's not a number you're going to do math with, just
    > use a Text field. You can set a validation rule forcing it to be all
    > numeric digits, if you like.
    >
    > --
    > Dirk Goldgar, MS Access MVP
    > www.datagnostics.com
    >
    > (please reply to the newsgroup)
    >
    >
    >
     
  5. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    Hassalls, I just use a Text field for ABNs.

    Like phone numbers and postcodes, these non-mathematical numbers can be
    easiest to store and format in text fields.

    If you want to use a Number field, use the Currency type.
    If you want to force 11 digits, set a Validation Rule of:
    Between 10000000000 And 99999999999

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "Hassalls" <Hassalls@discussions.microsoft.com> wrote in message
    news:5938CE45-110F-4573-BE66-C76C6364F21C@microsoft.com...
    > An ABN is short for Austrailian Business Number.
    >
    > thanks dirk
    >
    > "Dirk Goldgar" wrote:
    >
    >> "Hassalls" <Hassalls@discussions.microsoft.com> wrote in message
    >> news:CA3D64BD-AD72-49A3-8E59-E8D339C13E6A@microsoft.com
    >> > I want to create a contacts database and i would like to insert an
    >> > ABN for certain contacts.
    >> >
    >> > What field type do i use?
    >> >
    >> > I have tried integer and long integer but they say that the data is
    >> > not the right type.

    >>
    >> What's an ABN? If it's not a number you're going to do math with, just
    >> use a Text field. You can set a validation rule forcing it to be all
    >> numeric digits, if you like.
    >>
    >> --
    >> Dirk Goldgar, MS Access MVP
    >> www.datagnostics.com
    >>
    >> (please reply to the newsgroup)
     
  6. Jamie Collins

    Jamie Collins
    Expand Collapse
    Guest

    Hassalls wrote:
    > An ABN is short for Austrailian Business Number.


    >From a quick google, the type is text, either CHAR(11) or CHAR(14).


    This from a blog so take it with a grain of salt.

    http://www.jaguarpc.com/forums/showthread.php?t=13182&page=2

    "ABNs are 11 digits followed by a 3 digit group number.
    The first 11 digits are self validating via a simple checksum.
    The group number can't be 000. The group number starts with 001
    and is allocated incrementally.
    By convention when only one company in the group exists,
    the 001 group number is dropped."

    If you come up with a validation rule, post it here for the group.

    Jamie.

    --
     

Share This Page