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

    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 offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    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
    Posts
    168
    OHC Database2.8.zip

    attached File

    Password: Help

  4. #4
    accesstos's Avatar
    accesstos is offline Expert
    Windows XP Access 2007
    Join Date
    Dec 2018
    Location
    Greece
    Posts
    551
    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