Results 1 to 4 of 4
  1. #1
    jlzags is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    2

    Cool Calculation in a report

    I have a column with a sum total in the footer. I would like to subtract this calculated number from a constant (ie 20,000.00). Is this possible?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    20,849
    Sure; try either:

    =20000 - [TextboxName]

    =20000 - Sum(FieldName)
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    jlzags is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    2
    Is there a way to code a field so that it remains a constant number (currency amount)?

  4. #4
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,440
    in your query yes

    Just have something like

    Constantvalue: 40000

    then every line of your query will have a value of 40,000 in a field called ConstantValue

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

Similar Threads

  1. Query or Report Calculation
    By huber57 in forum Access
    Replies: 0
    Last Post: 03-27-2011, 11:33 AM
  2. Data variance calculation report
    By O2BSmart in forum Access
    Replies: 4
    Last Post: 08-10-2010, 09:35 AM
  3. lookup value for report calculation
    By josbor01 in forum Reports
    Replies: 0
    Last Post: 03-02-2010, 01:41 PM
  4. report average calculation
    By ZipDoc in forum Reports
    Replies: 1
    Last Post: 01-28-2010, 09:08 PM
  5. Report Calculation
    By thestclair in forum Reports
    Replies: 2
    Last Post: 03-28-2006, 12:23 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums