Results 1 to 6 of 6
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Sum Formula (Access 2000)

    Hi

    I have a field in a report called PartValue is derived from a query, I would like to have a sum of this field in the footer of my report.

    I have tried =sum([PartValue]) but I know this not correct, any help please.

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sum Formula (Access 2000)

    Is PartValue a field in the record source of the report? If so, a text box with control source =Sum([PartValue]) should work. If it is not a field in the record source of the report, can you explain what you mean by "I have a field in a report called PartValue is derived from a query"? I assume you didn't mean that the report is called PartValue.

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Sum Formula (Access 2000)

    If you want to sum a calculated field, then you need to include the calculated field in the query, rather than just put the calculation in the report.

    If you did that then I would expect =sum([PartValue]) to work.
    Regards
    John



  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sum Formula (Access 2000)

    A text box with control source =Sum([PartValue]) should do the job. You must put it in the Report footer section, not in the Page footer section.

  5. #5
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Sum Formula (Access 2000)

    Hi Hans

    I know I have not been very clear in what I am asking for. I created a qry from a table and then I created a report from that qry.

    If I say it simply I have a table with a field called PartValue, from that I created a form using autoform, then I created a qry from the table which included the said field and then I did a report on the qry.

    Braddy
    If you are a fool at forty, you will always be a fool

  6. #6
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Sum Formula (Access 2000)

    Hi Hans

    You spotted my mistake I put it in the Page footer and not the report. Thank you very much for your help.

    Braddy
    If you are a fool at forty, you will always be a fool

Posting Permissions

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