Results 1 to 5 of 5
  1. #1
    Blings's Avatar
    Blings is offline Competent Performer
    Windows 10 Office 365
    Join Date
    May 2020
    Location
    London, UK
    Posts
    125

    Syntax minus calculation

    Can someone help me sort the bottom syntax out, please?

    "Total Creditor Payment Less Discount" = [Balance as Per Statement] - ( [Less Credit] + [Discount] + [LP])



    Code:
    Total Creditor Payment Less Discount: ((Nz([Balance as Per Statement],0)-Nz([Less Credit],0))-Nz([Discount],0))-Nz([LP],0)

  2. #2
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    Quote Originally Posted by Blings View Post
    Can someone help me sort the bottom syntax out, please?

    "Total Creditor Payment Less Discount" = [Balance as Per Statement] - ( [Less Credit] + [Discount] + [LP])

    Code:
    Total Creditor Payment Less Discount: ((Nz([Balance as Per Statement],0)-Nz([Less Credit],0))-Nz([Discount],0))-Nz([LP],0)
    Too many parens, try this:

    Nz([Balance as Per Statement],0)-Nz([Less Credit],0)-Nz([Discount],0)-Nz([LP],0)

  3. #3
    Blings's Avatar
    Blings is offline Competent Performer
    Windows 10 Office 365
    Join Date
    May 2020
    Location
    London, UK
    Posts
    125
    Hello Dave,
    It still didn't work.
    Attached Thumbnails Attached Thumbnails TableCreditorRecon.PNG  

  4. #4
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,388
    It still didn't work.
    Helpful to know error message.
    Last edited by davegri; 07-31-2021 at 03:32 PM. Reason: See edit

  5. #5
    Blings's Avatar
    Blings is offline Competent Performer
    Windows 10 Office 365
    Join Date
    May 2020
    Location
    London, UK
    Posts
    125
    Quote Originally Posted by davegri View Post
    Helpful to know error message.
    Dave, I'm so sorry! It did work! See second last column. Time for bed. Thanks.

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

Similar Threads

  1. Running Sum & Minus.
    By cap.zadi in forum Queries
    Replies: 8
    Last Post: 09-27-2018, 04:53 AM
  2. Replies: 4
    Last Post: 01-04-2017, 07:34 PM
  3. Plus and Minus buttons
    By usaemtp in forum Forms
    Replies: 13
    Last Post: 01-30-2016, 08:45 PM
  4. Sum IF else minus
    By AussieGal in forum Access
    Replies: 2
    Last Post: 03-07-2013, 07:15 PM
  5. Workaround for MINUS (with Where)
    By Autoclave in forum Queries
    Replies: 2
    Last Post: 10-31-2011, 08:15 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