Results 1 to 4 of 4
  1. #1
    Tuckejam is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2020

    Calculated Column

    (for anyone who saw my other post about "IF THEN MATH" for calculating based on value in the date paid field, I have capitulated and added a "AmountPaid" field)

    Now my problem is I cant seem to get "= Sum([FineAmount]-[AmountPaid])" to work, I get an error

    "Your Query does not include the specified expression 'FinesID' as part of an aggregate function' (see image below)

    Click image for larger version. 

Name:	Capture.PNG 
Views:	14 
Size:	20.3 KB 
ID:	43410

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is online now Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Essex UK
    Can you post a copy of the db. Remove any sensitive data. Compact and Repair. Then zip it and attach the zip file to your post
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    Tuckejam is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2020

    attached File

    Password: Help

  4. #4
    accesstos's Avatar
    accesstos is offline Expert
    Windows XP Access 2007
    Join Date
    Dec 2018
    Just delete the Sum form field's expression and leave only the: TTL: ([FineAmount]-[AmountPaid])

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

Similar Threads

  1. Calculated column
    By MZobrist in forum Access
    Replies: 1
    Last Post: 02-23-2016, 03:35 AM
  2. Calculated Column in a Table
    By asmith533 in forum Programming
    Replies: 1
    Last Post: 02-10-2015, 07:53 AM
  3. Calculated Column
    By zbaker in forum Queries
    Replies: 1
    Last Post: 01-07-2015, 03:38 PM
  4. Calculated column in a report
    By beanhead0321 in forum Reports
    Replies: 2
    Last Post: 08-16-2011, 08:48 PM
  5. creating a calculated column
    By bold01 in forum Access
    Replies: 13
    Last Post: 02-10-2011, 08:17 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