Results 1 to 2 of 2

Thread: Report Total

  1. #1
    Join Date
    Aug 2004

    Question Unanswered: Report Total

    Who know how I can make a Total in a report??

    I have make a Report based on a Query. In the Report I have some records and I want sum this text fields. How I can???

    Please help me

  2. #2
    Join Date
    Oct 2003

    sum in report

    ok, in general you will use the =Sum([fieldname]) function in the control that will show your sum. In your case, since you have a text value you can't directly sum it, you must convert it first, with for instance the CInt() function to retrieve an integer value or a CDbl() to retrieve a decimal number. Check in the guide the conversion functions.

    So in your case you may want to use:


    in a control you'll create in the section at the end of report.

    I hope that helps.

    By the way, if you are using groups in your report you can add a total to each group for a certain field, just use the same function in the group header or footer area.

Posting Permissions

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