Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2005
    Posts
    20

    Exclamation Unanswered: Help With Report Calculations

    Hello,

    I am creating an access report. On the report I need the following information to be displayed on the report when it is viewed.

    Total Records in the report

    I also have a report field named charges...I need the following to appear on the report as well.

    Total sum of all numbers in the charges field to be displayed in a text box.

    Please help me with the code. I need to have this done by Tuesday!

    Thanks!!!

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    number of records is quite easy
    insert a report / page / group header as required
    insert a text box
    set the text box's data source "=count[<mycolumn>]", where <mycolumn> is a column in your report / reports underlying query

    sum is similar except
    insert a text box
    set the text box's data source "=sum[<mycolumn>]", where <mycolumn> is a column in your report / reports underlying query

    whilst you are at it it may be usefull to have a look at the other aggregation functions you cna use in reports in the help system
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •