Results 1 to 2 of 2
  1. #1
    JOAO PAULO is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2023
    Posts
    1

    function for total value in report

    I have a report with a ValorTotal field, and I need the report to show the sum of this total value field in another field, as there are several trips that this total value field calculates

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    add a text box to the rpt , bind it to the same field: ValorTotal
    if you want to use it in a calc, then the source will be : =ValorTotal * 12
    (where ValorTotal is the NAME of the text box on the report, not the field, but usually the same name)

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

Similar Threads

  1. Using Dmax +1 Function From Query Total??
    By Beanie_d83 in forum Queries
    Replies: 9
    Last Post: 04-27-2018, 05:48 AM
  2. Replies: 3
    Last Post: 01-18-2015, 06:05 PM
  3. NZ Function on Sum Total
    By kwooten in forum Queries
    Replies: 1
    Last Post: 11-28-2011, 04:09 PM
  4. Total Calculation, nz function, not working
    By Jojojo in forum Programming
    Replies: 3
    Last Post: 10-10-2011, 02:33 PM
  5. total many fields by function
    By thetuyen in forum Access
    Replies: 2
    Last Post: 03-08-2010, 08:43 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
  •  
Other Forums: Microsoft Office Forums