Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jul 2005
    Location
    Lancaster, Delaware, USA
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    fractional entries (Access 2000/ windows xp)

    Hello everyone,
    I have a question regarding calculations. I have an inventory database and some of my records quantity field are in feet, inches, etc. Now when a user enters a quantity they can only enter a whole number. So my question is can i set some property somewhere so that the users can enter say 1.235 feet of some cable. Any help as always is very much appreciated.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: fractional entries (Access 2000/ windows xp)

    Open the table in design view.
    Click in the quantity field.
    Set the Field Size property to Single or Double (it is probably Integer or Long Integer now).

    (Long) integers are whole numbers. Single and Double numbers can have a fractional part.

  3. #3
    Lounger
    Join Date
    Jul 2005
    Location
    Lancaster, Delaware, USA
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: fractional entries (Access 2000/ windows xp)

    Thanks Hans I will try it out.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •