Results 1 to 6 of 6
  1. #1
    angie is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Dec 2013
    Posts
    232

    Calucation of a unbound text box

    I have a text box (rate) and a unbound text box (percentage)
    Rate has a total

    I would like the unbound text box (percentage) to calculated the following

    rate -65.00 than show 15% of that total.

    I tried the following but didn't work

    =[rate]-6500 *.15

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    What does "didn't work" mean exactly? Did you include a decimal point for 65.? I'd add parentheses to clarify what should occur first.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    angie is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Dec 2013
    Posts
    232
    When I used the above in the text box it did not calculated the percentage

    I need to correct the above statement

    I need it to calculate as the following

    if (rate) is greater that 65.00 than do the following Rate - 65.00 and than calculated 15% of the balance and show that total.
    that is what I am needing to show in the unbound text box

    Thanks

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Along the lines of

    =IIf([Rate] > 65, ([Rate] - 65) * .15, 0)
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    angie is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Dec 2013
    Posts
    232
    That works great
    Thank you so Much

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Happy to help!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Using SQL with an unbound Text Box
    By Max2413 in forum Programming
    Replies: 5
    Last Post: 06-15-2016, 11:54 AM
  2. Calucation of Months between 2 records...
    By tanyalee123 in forum Queries
    Replies: 5
    Last Post: 05-09-2014, 02:45 PM
  3. Information text on unbound text box
    By randle in forum Forms
    Replies: 3
    Last Post: 06-28-2013, 11:43 AM
  4. Replies: 2
    Last Post: 06-11-2012, 09:37 AM
  5. Unbound text box truncating text
    By gddrew in forum Forms
    Replies: 0
    Last Post: 03-02-2006, 11:26 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