Results 1 to 7 of 7
  1. #1
    diane802 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2009
    Posts
    92

    Access 2007: Percent Format Issue

    Hi - I am trying to have a field be a Percent Format.

    In access 2007, I am reading that I should just have the properties be:

    Number
    - Field Size: Long Integer
    - Format: Percent
    - Decimal Places: 2



    However, in the table, when I enter a number that is smaller than 100 now, it automatically shows ZERO. When I enter 100, it shows it as 100% (and the same for any number above 100).

    Then, I tried to just change the format to General Number, with 2 decimal places.

    When I try to enter say, 0.45 - it changes it to zero. It does not show the two decimals. When I enter in 0.9, it rounds it up to 1

    Please advise.

    Thanks!

  2. #2
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    maybe reading it wrong.

    an integer - by definition - has no decimal places....so don't use integer - change to another number type and you should be fine.

  3. #3
    diane802 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2009
    Posts
    92
    i tried Decimal, as well as Single - they all continue to round it.

  4. #4
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    in A07 When I enter 100, it shows it as 100% - this is correct. it is literal .

    don't use decimal number type

    as to rounding; are you seeing this in the table itself or in a form? look in the table itself.

  5. #5
    diane802 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2009
    Posts
    92
    ah ok - it works now - i entered it now as:

    Field Size: Single
    Format: Percent
    Decimal Places: 2

  6. #6
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    in my Access2007 I create a table field defined as Number:
    Single
    Percent
    Auto

    and when I type in 3.45 it shows 3.45% as it should...

    do the same thing - and be sure you look directly at the table data and not at a form.

  7. #7
    diane802 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2009
    Posts
    92
    thanks NTC - the way I did it (as well as yours), makes it work now perfectly.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Issue with while loop and Access 2007 datasheet
    By jermaine123 in forum Programming
    Replies: 2
    Last Post: 01-17-2010, 10:09 AM
  2. MS Access 2003+Ms Excel 2007 Issue
    By putnum in forum Access
    Replies: 3
    Last Post: 12-20-2009, 09:24 PM
  3. Replies: 0
    Last Post: 11-17-2009, 02:35 PM
  4. MS Access 2007 - network interruption issue
    By shsh_shah in forum Access
    Replies: 5
    Last Post: 10-11-2009, 09:47 AM
  5. Replies: 0
    Last Post: 02-26-2009, 04:30 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums