Results 1 to 8 of 8
  1. #1
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows 7 32bit Access 2007
    Join Date
    Mar 2012
    Posts
    528

    How to add percentage to number

    Hello all
    Question


    How do I add a percentage to a field and show me another increase in field
    Example
    If the price was increased to 70 and 30%

    70 × 30
    ------------- = 21
    100

    70 +21 = 91

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    x + (x * 30 / 100)

    or

    x * (1 + 30/100)
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows 7 32bit Access 2007
    Join Date
    Mar 2012
    Posts
    528
    Thank you
    Did I can control the percentage is fixed and Make it through the field
    Click image for larger version. 

Name:	1.PNG 
Views:	17 
Size:	8.3 KB 
ID:	15797Click image for larger version. 

Name:	2.PNG 
Views:	17 
Size:	3.4 KB 
ID:	15798

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Don't understand the question.

    If the percentage varies, what field has the percentage value?

    Why are wages less than $1.00?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows 7 32bit Access 2007
    Join Date
    Mar 2012
    Posts
    528
    Yes, less than one dollar
    It cents

    My question was
    Is it possible to control the value of%
    I mean
    There are goods that we take 30%
    The Other 20%
    The Other 50%

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Yes, you can. Is there a table of goods with a field for the percentage? Include that table in the query and link on the PK/FK fields for the goods ID. Just another data relationship.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows 7 32bit Access 2007
    Join Date
    Mar 2012
    Posts
    528
    Good morning
    Thank you, teachers
    Where can I get these database example

  8. #8
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows 7 32bit Access 2007
    Join Date
    Mar 2012
    Posts
    528
    Is it possible to get an example

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

Similar Threads

  1. Return a Percentage
    By alecmat in forum Access
    Replies: 3
    Last Post: 08-07-2013, 08:06 PM
  2. Calculating Percentage
    By robsworld78 in forum Forms
    Replies: 17
    Last Post: 07-03-2011, 06:30 PM
  3. Calculating a Percentage
    By Alaska1 in forum Access
    Replies: 7
    Last Post: 12-13-2010, 05:57 PM
  4. Percentage Queries
    By bangemd in forum Queries
    Replies: 18
    Last Post: 05-21-2009, 09:32 AM
  5. percentage in a query
    By Peljo in forum Access
    Replies: 2
    Last Post: 02-27-2008, 10:51 AM

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